a little help please!
- Thread starter tico78
- Start date
spacepro
Registered User.
- Local time
- Today, 07:48
- Joined
- Jan 13, 2003
- Messages
- 715
The easiest way to do this is to create seperate queries for each customer with the fields you want on your report then use the create report wizard and select the query from the dropdown box and follow the instructions.
Basically create the report based on the query.
This will show the info that you require on each report.
HTH
Andy
Basically create the report based on the query.
This will show the info that you require on each report.
HTH
Andy
- Local time
- Today, 02:48
- Joined
- Feb 19, 2002
- Messages
- 47,599
It is not reasonable to create a query for each customer. What if you have thousands of customers?
Create a form with a combobox that displays customers. In the AfterUpdate event of the combo, use the OpenForm method to open your report. You can include the where argument to limit the report to just the customer selected by the combo. Look up help for OpenReport Method or search the archives here.
Create a form with a combobox that displays customers. In the AfterUpdate event of the combo, use the OpenForm method to open your report. You can include the where argument to limit the report to just the customer selected by the combo. Look up help for OpenReport Method or search the archives here.
Similar threads
