Can anyone help please. attached is my database if you open it and look at the jobs table i need to create a query that shows the employees that have worked for each location example:
Location Date Employee
BP Cleeton 01/02/03 Shaun Newman
BP CLeeton 01/02/03 Dino Paleschi
BP Cleeton 02/02/03 Shaun Newman
When i tried to create this query i put BP cleeton in criteria and it said data mistype. i messed with it and thought i had it working but it came back like this:
Location Date Employee
BP Cleeton 01/02/03 Shaun Newman
BP Cleeton 01/02/03 Shaun Newman
BP Cleeton 01/02/03 Shaun Newman
BP Cleeton 01/02/03 Dino Paleschi
BP Cleeton 01/02/03 Dino Peleschi
etc..
can anyone help me????? dane
Location Date Employee
BP Cleeton 01/02/03 Shaun Newman
BP CLeeton 01/02/03 Dino Paleschi
BP Cleeton 02/02/03 Shaun Newman
When i tried to create this query i put BP cleeton in criteria and it said data mistype. i messed with it and thought i had it working but it came back like this:
Location Date Employee
BP Cleeton 01/02/03 Shaun Newman
BP Cleeton 01/02/03 Shaun Newman
BP Cleeton 01/02/03 Shaun Newman
BP Cleeton 01/02/03 Dino Paleschi
BP Cleeton 01/02/03 Dino Peleschi
etc..
can anyone help me????? dane