Hi All,
I have the following problem;
I have an equipment management database which enables staff to book equipment etc.
The database has seperate tables for like equipment, people, business unit etc.
What I have currently is a query which shows existing bookings at that period of time, however, have had a request to create a query which shows available equipment.
I created a query which is call All Equipment and have the other one which shows existing bookings.
My theory was to Create a Query with both tables (Item Linked) and have the criteria as the following;
This is listed in the Items of the All Equipment Query.
For some reason it provides no returns, hoping that it would look at existing current bookings then look at all equipment and show the discrepencies? However, it doesn't seem to work. I have tried the opposite with an equals instead of <> and it returns the current.
Can anybody assist.
Cheers
I have the following problem;
I have an equipment management database which enables staff to book equipment etc.
The database has seperate tables for like equipment, people, business unit etc.
What I have currently is a query which shows existing bookings at that period of time, however, have had a request to create a query which shows available equipment.
I created a query which is call All Equipment and have the other one which shows existing bookings.
My theory was to Create a Query with both tables (Item Linked) and have the criteria as the following;
Code:
<>[Current Bookings]![Item]For some reason it provides no returns, hoping that it would look at existing current bookings then look at all equipment and show the discrepencies? However, it doesn't seem to work. I have tried the opposite with an equals instead of <> and it returns the current.
Can anybody assist.
Cheers
