I am trying to build a queries to identify office space. not all space is occupied during the week, how can I pull this information from the database?
I am trying to build a queries to identify office space. not all space is occupied during the week, how can I pull this information from the database?
That's a little ambiguous; are you looking to identify the unoccupied space? Presuming so, create a query that pulls what is occupied at the desired time, then use the unmatched query wizard to compare that against a table of all space.
Thanks Let me try that.
No problem, and welcome to the site by the way.