report showing all

[Melissa]

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

 

[Al Campagna]

Melissa,
You need to filter your report query to return just one Client record.
You would use the unique key field in your Clients table (ex.
[ClientID]) to do that.

Let's say you have a Client form called frmClients, based on your
tblClients... and on that form you have a text control bound to your
ClientID field, and called ClientID.
Now... say you're on a specific client's record, with a ClientID of
1452.
In your report query, and against the ClientID field, a criteria of...
= Forms!frmClients!ClientID
will filter the report to only return the record where ClientID = 1452.
(your form must stay open during the report)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Melissa]

hI

Thank you

That worked wonderfully for my Clients. i put a commandbutton on the
clients form, which opens the report, and shows which restaurants that
specific client is placed in.

Now in trying the same thing on the restaurantsForm. i created a query
which had RestaurantContractNo (primaryfield), and AdvertiserName (which is
linked to ClientId), and then criteria:
FORMS!Restaurants!RestaurantContractNo - its bringing up my report
blank?

My criteria for Clients query was: FORMS!Clients!ClientContractNo

why is my restaurant report blank>

thankyou, Melissa

Melissa,
You need to filter your report query to return just one Client record.
You would use the unique key field in your Clients table (ex.
[ClientID]) to do that.

Let's say you have a Client form called frmClients, based on your
tblClients... and on that form you have a text control bound to your
ClientID field, and called ClientID.
Now... say you're on a specific client's record, with a ClientID of
1452.
In your report query, and against the ClientID field, a criteria of...
= Forms!frmClients!ClientID
will filter the report to only return the record where ClientID = 1452.
(your form must stay open during the report)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

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

 

[Al Campagna]

Melissa,
If a report returns blank, then go to the query behind the report.

If you manually type in a legitimate RestaurantContractNo (RCN) into the
query... against the RCN field... does that return the record... or is the
query blank too?

If the query is blank, then there's a problem with your query.
If it does return the record you wanted, then the problem lies in your
"address" to the RCN field.

Given a field called RestaurantContractNo, on the main part of a form
named Restaurants, and that form is open when the query runs, then...
= Forms!Restaurants!RestaurantContractNo
should do it. Please recheck everything again... because that should work
if all is as you say.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

hI

Thank you

That worked wonderfully for my Clients. i put a commandbutton on the
clients form, which opens the report, and shows which restaurants that
specific client is placed in.

Now in trying the same thing on the restaurantsForm. i created a query
which had RestaurantContractNo (primaryfield), and AdvertiserName (which
is linked to ClientId), and then criteria:
FORMS!Restaurants!RestaurantContractNo - its bringing up my report
blank?

My criteria for Clients query was: FORMS!Clients!ClientContractNo

why is my restaurant report blank>

thankyou, Melissa

Melissa,
You need to filter your report query to return just one Client record.
You would use the unique key field in your Clients table (ex.
[ClientID]) to do that.

Let's say you have a Client form called frmClients, based on your
tblClients... and on that form you have a text control bound to your
ClientID field, and called ClientID.
Now... say you're on a specific client's record, with a ClientID of
1452.
In your report query, and against the ClientID field, a criteria of...
= Forms!frmClients!ClientID
will filter the report to only return the record where ClientID = 1452.
(your form must stay open during the report)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

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