Filter for Report

[Guest]

Can I set up a report so that it will show only one client instead of all 180
of them?

 

[Guest]

Let me restate, can I set up a filter for a report so that it will show the
report for a specified customer or date range, etc.

 

[Duane Hookom]

Sure, check the 2nd article listed at
http://www.mvps.org/access/reports/index.html.

 

[Guest]

I don't think this way will work with the way things are set up.

However, I did try setting parameters for the query that the report is based
on so that the user will be promted to enter criteria (such as a last name)
to generate the report. In the query I have it set up so that the criteria
under the last name column looks like this [Enter Client's Last Name] and I
have the same in the first name column. When I go to run the report, I am
promted to enter the first and last name, but the entire client list is still
coming up. please advise.

 

[Duane Hookom]

Please provide the SQL view of your report's Record Source.

--
Duane Hookom
MS Access MVP

I don't think this way will work with the way things are set up.

However, I did try setting parameters for the query that the report is
based
on so that the user will be promted to enter criteria (such as a last
name)
to generate the report. In the query I have it set up so that the
criteria
under the last name column looks like this [Enter Client's Last Name] and
I
have the same in the first name column. When I go to run the report, I am
promted to enter the first and last name, but the entire client list is
still
coming up. please advise.

Sure, check the 2nd article listed at
http://www.mvps.org/access/reports/index.html.

 

[Guest]

How do I find that?

Please provide the SQL view of your report's Record Source.

--
Duane Hookom
MS Access MVP

I don't think this way will work with the way things are set up.

However, I did try setting parameters for the query that the report is
based
on so that the user will be promted to enter criteria (such as a last
name)
to generate the report. In the query I have it set up so that the
criteria
under the last name column looks like this [Enter Client's Last Name] and
I
have the same in the first name column. When I go to run the report, I am
promted to enter the first and last name, but the entire client list is
still
coming up. please advise.

Sure, check the 2nd article listed at
http://www.mvps.org/access/reports/index.html.

--
Duane Hookom
MS Access MVP

Can I set up a report so that it will show only one client instead of
all
180
of them?

 

[Duane Hookom]

View the report properties and find the Record Source property. You should
be able to go to the design view of the Record Source and View->SQL view.
Copy this and paste it in a reply.

--
Duane Hookom
MS Access MVP

How do I find that?

Please provide the SQL view of your report's Record Source.

--
Duane Hookom
MS Access MVP

I don't think this way will work with the way things are set up.

However, I did try setting parameters for the query that the report is
based
on so that the user will be promted to enter criteria (such as a last
name)
to generate the report. In the query I have it set up so that the
criteria
under the last name column looks like this [Enter Client's Last Name]
and
I
have the same in the first name column. When I go to run the report, I
am
promted to enter the first and last name, but the entire client list is
still
coming up. please advise.

:

Sure, check the 2nd article listed at
http://www.mvps.org/access/reports/index.html.

--
Duane Hookom
MS Access MVP

Can I set up a report so that it will show only one client instead
of
all
180
of them?