Hi,
I am new to access and am trying to create a query.
i have 2 tables that I need to get the required information from, Table "Data" & "Machine"
What I am trying to get is the user enters the shift commencing date and shift number and the query to list all the machines that are related to this shift which is gained from the "Machine" table and also to show the date the machine was cleaned if it is >= the date entered by the user from the "Data" table.
I can get the first part working but as soon as I try to get the machine cleaned data it on displays the machines that have been cleaned and not all of the machines if they have been cleaned or not.
any help would be great.
I am new to access and am trying to create a query.
i have 2 tables that I need to get the required information from, Table "Data" & "Machine"
What I am trying to get is the user enters the shift commencing date and shift number and the query to list all the machines that are related to this shift which is gained from the "Machine" table and also to show the date the machine was cleaned if it is >= the date entered by the user from the "Data" table.
I can get the first part working but as soon as I try to get the machine cleaned data it on displays the machines that have been cleaned and not all of the machines if they have been cleaned or not.
any help would be great.