Report Selection in Access

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

If I have a report that has sorts by a location, how can I select when I run
the report to only show a specific location. If you could please help me
out, thanks.
 
On Thu, 28 Feb 2008 05:55:00 -0800, Anthony

You need a criteria form. Provide a dropdown with locations. User
selects one and clicks the Run Report button. You then write
DoCmd.OpenReport and in its WhereClause argument you specify something
like:
"Location = " & Me.cboLocations
If the locations are text, wrap the value in single quotes:
"Location = '" & Me.cboLocations & "'"

-Tom.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Hours over 24 hours in Access Report 0
Display description not ID 2
Access 2010 Report Button 0
Building a Report 3
Query which Value Returns Previous Record 8
Reports 8
Access Access Report Works on One Machine but not Another 3
Reporting on selected information 7

Back
Top