G Guest Aug 10, 2005 #1 I would like to sometimes run a parameter query but see all of the data and not just certain criteria. Is there a way to do this?
I would like to sometimes run a parameter query but see all of the data and not just certain criteria. Is there a way to do this?
F fredg Aug 10, 2005 #2 I would like to sometimes run a parameter query but see all of the data and not just certain criteria. Is there a way to do this? Click to expand... Several ways, depending upon what you are using as criteria. As an example: WHERE YourTable.YourField Like [Enter Criteria] & "*" OR [Enter Criteria] Is Null or... WHERE YourTable.YourField = [Enter Criteria] OR [Enter Criteria] Is Null etc.
I would like to sometimes run a parameter query but see all of the data and not just certain criteria. Is there a way to do this? Click to expand... Several ways, depending upon what you are using as criteria. As an example: WHERE YourTable.YourField Like [Enter Criteria] & "*" OR [Enter Criteria] Is Null or... WHERE YourTable.YourField = [Enter Criteria] OR [Enter Criteria] Is Null etc.
