Help with writing query

Damo10

Registered User.
Local time
Today, 23:43
Joined
Jun 20, 2013
Messages
12
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.
 
Hi,

Here are the 2 tables
 

Attachments

Users who are viewing this thread

Back
Top Bottom