filtering data

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

Guest

I am trying to filter a database that tracks Work Procedures. I to have the
query ask which unit or units they are looking for.
 
Donna said:
I am trying to filter a database that tracks Work Procedures. I to have the
query ask which unit or units they are looking for.
Click to expand...

you can add a parameter to it, but you can only specify a single
match... well, unless you throw in an OR clause. The most flexible way
is to use a form to collect criteria and then open a report based on
the query and filter in the Open event of the report.

otherwise, you'd have to modify the WHERE clause of the query on the
fly using VB.
 
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

Building two expressions in one query 3
Filtering records for 2 types of dates 10
Refer to a query in qry of rpt 1
Query Equation 2
Append query to another database 1
What are the steps to fix damaged MDF files in SQL Server? 0
Show only most recent record record 0
Query using text from form or anything if empty 2

Back
Top