Count Feild

[Curtis Moxam]

Hello,


I am designing a database that deals with renting movies. In one table I have two columns, the total quantity in and the total quantity out for each movie. Beside these columns I have a column called number of times rented. I want to create a macro that counts the amount of times each movie is ordered based on the number of orders for that movie number in another Orders table. Any help would be appreciated.

[June7]

The number of times rented should not be a value in table. It should be calculated when needed by doing an aggregate Totals (GROUP BY) query on the Orders table.

[Curtis Moxam]

I will do that. Its a good option that I never thought of before.