Access Reports

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

Guest

I am trying to write a report for Access that has multiple criteria. I know
that you can have it set so that it will ask you for the criteria you want,
but what if there is multiple criteria. Such as I want information from the
database on everyone in the US and Canada and Mexico. I know I can have it
set to ask where from and I can say the US but how can I have it set so that
I can say all three countries or two of them or more than that?
 
Check this link on "Use Multi-Select List boxes as query parameters"
http://www.mvps.org/access/forms/frm0007.htm

So you can create a form with a list box where you can select as many
countries that you want and the report will be filtered.

**************************************
In addition to the code above, in the end of it you can write

' create a query for that purpose, empty query and the code enter the SQL to
it
application.CurrentDb.QueryDefs("QueryName").SQL = strSQL
' Base the report on that query
Docmd.OpenReport "ReportNAme"
 

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

Back
Top