parameter query

[zezo]

Hi, I need help to finish my Query, I want to let the user put a serial
number to get it or put several serial numbers or collect it all
so I did this ...
(',' & [Enter SN's] & ',') Like ('*[, ]' & [Requisition Lines]![SN] & '[, ]*')
this is work to give a specific serial, but if I want let the users show all
serial numbers by clicking enter without write any number what is missing in
this ???

I appreciate ur cooperation

 

[John Spencer]

Try entering the following as the criteria:

((',' & [Enter SN's] & ',') Like ('*[, ]' & [Requisition Lines]![SN] & '[,
]*') OR [Enter SN's] is Null)

If you are doing this using design view you should have two columns that look like

Field: Expr1: ',' & [Enter SN's] & ','
Criteria(1): Like ('*,' & [Requisition Lines]![SN] & ',*'
Criteria(2): <LEAVE BLANK>

Field: Expr2: [Enter SN's]
Criteria(1): <LEAVE BLANK>
Criteria(2): Is Null

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County