I am trying to create a query that shows the "first name" and "last name" of the choir member only if the check out "date out" is not null -and- the check out "date in" is null. Is there a way I can do this?
Hi Zeroaccess, thank you for your reply. It is not quite that simple, although what I actually need might be, I do not know! I need the query to return as it does below, but I need the "First Name" and "Last Name" columns for the three tenor copies to be blank since the "DateIn" column for those three is not null. If I simply type "Is Not Null" for DateOut and Is Null for DateIn, then the only record that will return is the one for Soprano Copy 1.
If the expression I gave you works the way you want, use the same logic for Last name. What comes before the colon is the name of the calculated field. Note that it must be different than any field name in the record source. Since your first name has a space (which isn't a good idea to use), I simply took it out.