- Joined
- May 10, 2012
- Messages
- 1
- Reaction score
- 0
In my access database 2007, I want to create a query expression for my “Visit” column. The query expression should number each
customerID in chronological order based upon the date. See example below.
How do I create this column in SQL or in query view (without SQL)? I prefer doing it without SQL or VBA since I have minimal experience. However, I'm willing to tryl.
CustomerID Date Visit
999999 1/1/12 1
999999 2/1/12 2
666666 3/1/12 1
999999 4/2/12 3
666666 4/30/12 2
customerID in chronological order based upon the date. See example below.
How do I create this column in SQL or in query view (without SQL)? I prefer doing it without SQL or VBA since I have minimal experience. However, I'm willing to tryl.
CustomerID Date Visit
999999 1/1/12 1
999999 2/1/12 2
666666 3/1/12 1
999999 4/2/12 3
666666 4/30/12 2