report showing all

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi there

I have three tables. One is for "Clients", the other is "Restaurants', and the other is "Ads.

(the clients advertise in the restaurants).

I have a form for "Clients", with a button which opens the "ads subform" in order to choose which restaurants that specific client is advertising in.

this is all working fine. But when i create a report to show the ClientContractNo, ClientName, Name of restaurants placed in, and so on, the report brings all the necesary info up, but for ALL OF THE CLIENTS on the same report.

how do i create a report "Per Client" to show just that specific clients info and restaurants, and then also a seperate report - "Per Restaurant", to show which clients advertise in a specific restaurant?

Please help me

thank you kindly

Melissa

.

Quantcast