AnsweredAssumed Answered

How to count specific products in all orders??

Question asked by jhowlin on Apr 6, 2011
Latest reply on Apr 7, 2011 by philmodjunk

Title

How to count specific products in all orders??

Post

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? 

Thanks!

Jason

Outcomes