Solved TempVars as Query criteria

[ClaraBarton]

Just so you know... I never completely understand what I'm doing and I'm okay with that. Some of us are doomed to be in a fog You put way more time into this than I deserve and I very much appreciate it. Thank you so much.

 

[Pat Hartman]

You're welcome. Do you now understand that Null is NEVER = to something? Null is also NEVER <> to something. You ALWAYS have to deal with null separately and specifically whether you want to include rows with null in a particular column or rows that are not null in a specific column. Write yourself a note And the only way to do this is by using the function IsNull() when working with VBA or the SQL express on Is Null when working in a query. IsNull() also works in a query but always use SQL Syntax in a query when both are available.

 

[ClaraBarton]

Gotcha!!!