Multiple Criteria from Qry Dialogue Box

  • Thread starter Thread starter Gary Brett
  • Start date Start date
G

Gary Brett

Hi.
I am fairly sure this is easy for a VBA expert, but clearly I am not!
I have a query with 4 fields in, 1 of which is named MailLevel and
this field contains numbers ranged 1-9. In the Qry design grid I have
input [Enter Mail Level] that produces a pop up dialogue box which
asks that very question. If the user inputs 2 for example it produces
the qry with just Mail level 2 showing. What I need to achive is to
enable the users to input multiple choices to filter.
ie: They type 1,2,5,6,9 into the pop up dialogue box and all matching
records are shown in the query..
Thanx for your time in advance...

G
 
WHERE Instr([Enter Mail Levels],[MailLevel])>0
This will work only if you don't have two digit numbers. There is a
work-around if this is the case.
 
Duane Hookom said:
WHERE Instr([Enter Mail Levels],[MailLevel])>0
This will work only if you don't have two digit numbers. There is a
work-around if this is the case.

--
Duane Hookom
MS Access MVP


Gary Brett said:
Hi.
I am fairly sure this is easy for a VBA expert, but clearly I am not!
I have a query with 4 fields in, 1 of which is named MailLevel and
this field contains numbers ranged 1-9. In the Qry design grid I have
input [Enter Mail Level] that produces a pop up dialogue box which
asks that very question. If the user inputs 2 for example it produces
the qry with just Mail level 2 showing. What I need to achive is to
enable the users to input multiple choices to filter.
ie: They type 1,2,5,6,9 into the pop up dialogue box and all matching
records are shown in the query..
Thanx for your time in advance...

G
Click to expand...
Click to expand...


Genious...

Thanx very much for yourtime & effort Duane

Have a good day

G
 
Back
Top