MS Access 2007 - I need a special query

[odrap]

I need to assemble information about de buying history of clients. That means , that i need to view all articles that the client have ordered in the past, the date each article was last ordered as well as the quantity that was ordered, as well as the number of times each article has been ordered from the past to now.
Can that be realized by query ?

 

[DCrake]

Yes that should be ok. Drag the tables and fields down to your query and filter by client. Then use the count and sum aggregates in the totals query. As long as you have the base info you should be able to get the summary info.

David

 

[odrap]

Thanks very much for the help. I give it a try