Print a report

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

Guest

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
 
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
Click to expand...

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

-Kris
 
How would i feed these results to the report and print a single report for
each user that was picked up from the list
 
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.
 
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
 
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.
 
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
Click to expand...

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
 
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
 
Back
Top