Print a report

[The Uke]

Ok i have a report that has a critria userid I wanted to know if and how
there is a way to print the report based upon a list or query of the user ids

 

[krissco]

Ok i have a report that has a critria userid I wanted to know if and how
there is a way to print the report based upon a list or query of the user ids

Yep. Where does your list come from? Is the user specifying from a
form? Is the list stored in a table?

-Kris

 

[Duane Hookom]

There are quite a few examples on the web of using a multi-select list box as
the criteria for opening a report. There is a generic function for doing this
at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[The Uke]

How would i feed these results to the report and print a single report for
each user that was picked up from the list

 

[mrsthreestrands]

I'm a new Access user, but I did this by creating a filter (a query) & using
a macro to open the report. In the bottom half of the macro window there is
a space for you to list the filter.

 

[The Uke]

yea but the filter is for the where part of the SQL statement
The part that i need to worry about form the sql statement is the HAVING part

 

[Duane Hookom]

You can use the generic listbox function I suggested. The query that uses the
generic listbox function can be used as the record source of your report.

 

[krissco]

yea but the filter is for the where part of the SQL statement
The part that i need to worry about form the sql statement is the HAVING part

This is somewhat off-subject, but you can easily change a HAVING
clause into a WHERE.

Assuming you are actually using a HAVING clause (aggregated values) -
Access likes to place WHERE criteria in HAVING even when it is not
necessary.

Old query:
Select myID
from tblSomething
group by myID
having count(*) > 4

New queries. Save the first one as a view.
qryMyQuery:
Select myID, count(*) as myCount
from tblSomething
group by myID.

select myID
from qryMyQuery
where myCount > 4.

Ta-Da. Changed HAVING to WHERE by saving as a view and then selecting
from it.

BTW, I'm still not sure where your limiting/filtering data is coming
from.

-Kris

 

[The Uke]

yes but i only want one response per report
Either way I just make a drop down box and set that as the control source
for the report with a macro to print or preview
Its not prefect but it does what i kinda want it to do no loop but it does
work