J
jmcarroll7
Can I set up a report so that it will show only one client instead of all 180
of them?
of them?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
jmcarroll7
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.
report for a specified customer or date range, etc.
D
Duane Hookom
Sure, check the 2nd article listed at
http://www.mvps.org/access/reports/index.html.
http://www.mvps.org/access/reports/index.html.
J
jmcarroll7
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.
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.
D
Duane Hookom
Please provide the SQL view of your report's Record Source.
--
Duane Hookom
MS Access MVP
--
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.
J
jmcarroll7
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?
D
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
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?