Hello,
would someone please be so kind and help me with this problem.
i have this query that lists a number of order numbers on different rows however according to the query criteria the same order number may appear on many rows.
what i need to do is number these order numbers as follows
Order Number record number
123456 1
123456 2
123456 3
7890 1
7890 2
7890 3
and so on
please help
thanks
Lee-Anne
--
Message posted via http://www.accessmonster.com