By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,933 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,933 IT Pros & Developers. It's quick & easy.

How do you consecutively number rows in an aggregate query

P: 24
How do you consecutively number rows in an aggregate query?
Dec 17 '07 #1
Share this Question
Share on Google+
1 Reply


Denburt
Expert 100+
P: 1,356
How do you consecutively number rows in an aggregate query?
That is an interesting question and one that doesn't have a straightforward answer. The best advice I could give is to create a form and view it in a datasheet format...

Depending on what you are doing it could possibly be done but would take some effort and would likely yield unpredictable results (in a query). Yet if you still want to give it a try take a look at the following link and it may give you some ideas on how you can accomplish this feat.

http://support.microsoft.com/kb/290136

Happy coding, let us know how things go.
Dec 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.