Recent content by CluelessInSeattle

  1. C

    If-And-Then?

    Hi Crystal, thank you for your reply - that is exactly what I needed and I was able to do it for Last Name as well as you said. Thank you so much!!
  2. C

    If-And-Then?

    Hi theDBguy, thank you for your reply. Would I do that in SQL view?
  3. C

    If-And-Then?

    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...
  4. C

    If-And-Then?

    Hello all, 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?
See more
Top Bottom