Autonumbering a database results query

[bebo2]

Hi,
I am posting the results of a query thru FrontPage by using "Database Results" and the Query(view). I have a request to number the results (which will vary as the data changes). Can you tell me how (if possible) to do that - can't seem to do it in Front Page - is there a way to have it as an added column in the query end?
Thanks!

 

[bebo2]

doesn't work for me

Hey thank you very much - cool site!!! Unfortunately, the code doesn't work for my queries - none of them work. I have a parameter on the query - a check box which is "true". Not sure if that is what throws a kink in it or not and not sure how to move around that. I even tried using the number 1 - this is the code I tried that got past the "you did it wrong" messages but still not provide the results I was looking for:

Sequence: DCount("AH","ProviderResources","AH = True") which returns the number 25 for all records and is the number of records that are returned with that parameter - I would be happy with that number showing up in Front Page as the sum of records returned....

I appreciate your help and will respond accordingly!!
Barb

 

[Jon K]

To use DCount() to produce the Sequence, you have to use a field that can satisfy two conditions:-
1. It contains no duplicate values.
2. Its values can be compared using <=.

A Yes/No field does not satisfy these conditions.

Note. Using DCount() or a subquery may take time if the table is fairly large or the system is slow.

 

[bebo2]

Ok - well that it explains it! Thank you! Barb