[RHY-07]

hey probably a real simple/dumb question but i cannot say how much access drives me mad so im hoping one of you can save me time and much much annoyance

k basically i need to create a report, the report needs to be created on what a user wants tho...

say i have a database table with customers, another with products and a linking table to say who bought what.. can i create a user-friendly menu (like a menu/form) where the user could select a customer from a combo box, then click a button and have access create a report on what the selected customer has bought?

i think i need to create a query n sumhow have access change the search criteria depending on what the user wants... but i might be wrong, pleeaassee someone help

[Anne Troy]

It's called "query by form". I don't know what version you have, but here's one:
http://support.microsoft.com/kb/209645

[RHY-07]

thanks alot, took a while but i got what i wanted, thanks again