Filter for Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I set up a report so that it will show only one client instead of all 180
of them?
 
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.
 
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.
 
Please provide the SQL view of your report's Record Source.

--
Duane Hookom
MS Access MVP

jmcarroll7 said:
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 said:
Sure, check the 2nd article listed at
http://www.mvps.org/access/reports/index.html.
Click to expand...
Click to expand...
 
How do I find that?

Duane Hookom said:
Please provide the SQL view of your report's Record Source.

--
Duane Hookom
MS Access MVP

jmcarroll7 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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

jmcarroll7 said:
How do I find that?

Duane Hookom said:
Please provide the SQL view of your report's Record Source.

--
Duane Hookom
MS Access MVP

jmcarroll7 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top