Any Function available to Serialise the Queries?

[prabhafriend]

Are there any function available to include serial numbers in Query? I believe there must be some way to achieve this. Help needed.

[geekgirlau]

Can you provide more information? What is it that you're trying to do?

[prabhafriend]

A Functionality like the 'ROWNUM' in Ms-Access

[CreganTur]

Are you wanting your query to create a serial number or use it as a parameter? If neither, then please explain in more detail what you're trying to do.

[geekgirlau]

If you're after a sequential list of numbers, you can do something like the following. Be warned however that this can be slow depending on your data. This assumes that the ID field is unique.

SELECT ID, DCount("[ID]","MyTable","[ID]<=" & [ID]) AS RowNum
FROM MyTable