Numbering Visits

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top