Select criteria for report

[kez]

Hi All

I have created a report based on a query based on 2 tables - one with client name & client id and the other with client visits eg date, details, invoice amt and paid etc. The report shows all clients with all client visits.

I would like to select from a list box a single client and show all the visits on the report. I did create a list box but the box showed single visits and I would like to show all the visits. I have searched the forum but haven't been able to find exactly what I need, I know it's probably there somewhere but I haven't had much luck to date.

If anyone can help me it is greatly appreciated.

 

[whatever]

I would tackle this with a linked subreport.

1. Create and save a new report which lists all your client visits, this will be your subreport, you need to include client ID on this report.

2. Create a new master report which has a page per client again including Client ID.

3. whilst in design mode on your master report insert your subreport by using the subreport icon from the toolbox menu bar, this will fire up the wizard asking you for a subreportname and your linked fields.

You should then be good to go.


HTH.



Kevin

 

[kez]

Many Thanks

I hadn't thought of that solution I was looking for a combo box or list box.

But your solution will work better for me.

Once again thanks again I don't know what we (the not so well informed)would all do without this forum.

Kez