Criteria Line of a field

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

Guest

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
 
change your criteria to...


Like [Enter Org Number] & "*"


To allow the user to leave it blank for all.

Rick B
 
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...
 
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]),"*");
 
Back
Top