G
Guest
How do I assign a line numbers in a query....I have a table that lists events
and the date of the event, this table contains many events and some events
can occur twice in one day...in that case we use an event number such as
64050506-1 and 64050506-2. I have a parameter query that shows only the
records between 2 dates...most of the time it's for a full month...example
5/1/06 thru 5/31/06. I need to be able to number the lines in consequitive
order but when I have 2 events in the same day it does not number the lines
individually. If event 64050506-1 is 4 then event 64050506-2 ends up being
numbered as 4 as well. How do I get around this problem? Thank you for all
the help extended to a novice such as myself...it is very appreciated.
Doris
and the date of the event, this table contains many events and some events
can occur twice in one day...in that case we use an event number such as
64050506-1 and 64050506-2. I have a parameter query that shows only the
records between 2 dates...most of the time it's for a full month...example
5/1/06 thru 5/31/06. I need to be able to number the lines in consequitive
order but when I have 2 events in the same day it does not number the lines
individually. If event 64050506-1 is 4 then event 64050506-2 ends up being
numbered as 4 as well. How do I get around this problem? Thank you for all
the help extended to a novice such as myself...it is very appreciated.
Doris