Filter Report

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

Guest

I have a purchase order system. I have a report that is based on a query I
created. It works fine, showing the correct information. But, it shows all
the orders that have been created. Can I edit my query or SQL statement or
apply a filter to only show the most recently created order? Please Help!

Thanks!
 
A couple approaches:

1 - if you are working from a form (you ARE working from a form, right?),
you could modify the code behind the <Print This> command button to use
either the filter or the where syntax in the DoCmd.OpenReport command; or
2 - you could modify the query you use for the report to get an ID# from the
form (?you ARE using a form, right?!) on which the ID# is selected. The
criterion in the query would look something like:

Forms!YourFormName!TheNameOfTheControl

Good luck!

Jeff Boyce
<Access MVP>
 
Back
Top