How to count specific products in all orders??
I have an orders table, a products table, and a titles table. Orders can have multiple productsin them, and products can have multiple titles. I have join tables to connect them.
I am trying to count the number of a specific TITLE sold in a certain time period. I tried a summary field in the titles table, but it counts all the titles in an order. I don't know how to specify to count only a specific title.
Does anyone have an idea how to accomplish this??? Should I be basing my layout / report on the orders table or the titles table?