RoyalYoshi
New member
- Local time
- Today, 12:25
- Joined
- May 21, 2012
- Messages
- 3
Hi I'm fairly new to Access and would like a bit of assistance.
I have tables called tblCustomers, tblStock and tblOrders.
One of the fields need to be an OrderCount field, which is supposed to increase by 1 every time a customer orders.
For example, whenever Bob orders something for the first time, his OrderCount would be 1. The next time he orders something, his OrderCount would be 2 and so on.
How would I go about doing this in a query (using a query is my only option, unfortunately)?
Also, it would have to be done for different customers as well (e.g., Bob, Steven, Max, etc.) in order to calculate their counts.
I have tables called tblCustomers, tblStock and tblOrders.
One of the fields need to be an OrderCount field, which is supposed to increase by 1 every time a customer orders.
For example, whenever Bob orders something for the first time, his OrderCount would be 1. The next time he orders something, his OrderCount would be 2 and so on.
How would I go about doing this in a query (using a query is my only option, unfortunately)?
Also, it would have to be done for different customers as well (e.g., Bob, Steven, Max, etc.) in order to calculate their counts.