By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,128 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,128 IT Pros & Developers. It's quick & easy.

Search for all rows and records of a particular client

P: 1

I am doing a database for my beutition shop. I created a table called slimming, which i store the clients info (including ID card number), the date of the appointment, the type of therapy the client took that particular date, and the weight of the client.

I created form so that I will enter the information from this form. For every slimming appointment I have to enter the information of every client in a separate form. Then I created a report which shows all the clients information in one report. I grouped the informmation by the ID card number so that the slimming appointments of that particular client will be grouped together.

This report can be accessed by pressing a button that will open the preview of the report. When I open the report, I have to press ctrl + F and enter the ID card number the particular client, to find all the appointments of that client.

Can you please tell me how can I do to improve my method? For example do a table or form that will display certain amount of rows to enter this information. Or else some kind of filtering in the report, to display all the information of one client.

Thanks a lot for your help

Aug 4 '08 #1
Share this Question
Share on Google+
1 Reply

P: 167
Hi Sue!

Obviously your report displays the info you need, but it also displays alot you don't need at the time.
You could have two reports. One displaying all clients, and the other displaying info for current client only.
[HTML]You should copy the report you have and name it say Report2.
You than copy Query on which the ReportAll is based and name it Query2.
Now control source property of Report2 set to Query2.
in Query2 go to design view and in criteria row put a reference to current clientID on your form. Like: =Forms!MyForm!ClientID[/HTML]
This way Query2 will display only records for current client.

Also there is a lot on queries in MSaccess help.
Aug 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.