I have this query:
Select Max(SessionID) FROM Session WHERE ObjectID = [Enter CatID] And
LevelID = 2 And [EndTime] Is Null
I want to be able to use a parameter to be able to switch at will from
AND [EndTime] Is Null
AND [EndTime] Is NOT Null
Obviously, this is to be able to return values from only closed sessions or
from only open sessions. I haven't encountered this syntax before in my
work with Access, so I am a bit unsure as to how to phrase this.
Does anyone have any ideas?