query/report help!

[tico78]

I need to make a report of every client with his information stored my database (Access). HOw can I do that? Do I need to create a comand button in the FORM of the client, or a QUERY?

I tried, but I get just one report with all the clients and their info (in just one report), and I need a report of every client individually..
please HELP!
thanks

 

[Bryan F]

you should read the docs on how to create a where clause... when you open the report you can add in a where clause in vb

docmd.openreport "ReportName", acViewPreview, , "CustomerID = " & Forms!MyForm!CustomerID

this will limit your one big report with all customers down to one customer id

 

[Pat Hartman]

Please do not post the same question under multiple topics. You are accumulating a collection of responses and wasting peoples time.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43835

 

[tico78]

my apologies for the same question

sorry, it will not happen again.