Criteria Line of a field

M

MacNut

If I have [Enter Org Number] in the criteria box for a specific field in a
query, is there SOME WAY at run time that that prompt can be ignored OR is
there a special character that can be entered that shows ALL the records then?

Thanks
 
R

Rick B

change your criteria to...


Like [Enter Org Number] & "*"


To allow the user to leave it blank for all.

Rick B
 
M

MacNut

Worked like a charm. Thank you so much !

Rick B said:
change your criteria to...


Like [Enter Org Number] & "*"


To allow the user to leave it blank for all.

Rick B

MacNut said:
If I have [Enter Org Number] in the criteria box for a specific field in a
query, is there SOME WAY at run time that that prompt can be ignored OR is
there a special character that can be entered that shows ALL the records then?

Thanks
Click to expand...
Click to expand...
 
F

fredg

If I have [Enter Org Number] in the criteria box for a specific field in a
query, is there SOME WAY at run time that that prompt can be ignored OR is
there a special character that can be entered that shows ALL the records then?

Thanks
Click to expand...


WHERE YourTable.[OrgNumber] =[Enter Org Number] OR
YourTable.OrgNumber] Like IIf(IsNull([Enter Org Number]),"*");
 
Top