Hi All, I am a NEWBIE to this site and use ACCESS at work to create very simple databases that my Engineering team can use to create automated reports and information archives. I'm in the process of creating a new database but cant seem to figure out how to confgiure my queries to get the information i want.
Example - ENGINEERS Daily REPORT "EQUIPMENT" worked on and "TIME SPENT WORKING"
I created the main table using dropdown menus so the Engineers can
select any of the mutitude of equipments that can be worked on in our factory. and have a minimum 30 different possible fields to reference to equipments within a single working shift
E.G
JOB 1 EQUIPMENT 1 TIME 1 DETAILS 1
JOB 2 EQUIPMENT 2 TIME 2 DETAILS 2..... and so on
But when i try to create a query to say check "every daily report" and
"Look at Everytime a particular machine was worked on or the total amount of time spent working on a particular machine ?
It will only give me the 1st job done.
Any advice gratefully recieved
SHREK
Example - ENGINEERS Daily REPORT "EQUIPMENT" worked on and "TIME SPENT WORKING"
I created the main table using dropdown menus so the Engineers can
select any of the mutitude of equipments that can be worked on in our factory. and have a minimum 30 different possible fields to reference to equipments within a single working shift
E.G
JOB 1 EQUIPMENT 1 TIME 1 DETAILS 1
JOB 2 EQUIPMENT 2 TIME 2 DETAILS 2..... and so on
But when i try to create a query to say check "every daily report" and
"Look at Everytime a particular machine was worked on or the total amount of time spent working on a particular machine ?
It will only give me the 1st job done.
Any advice gratefully recieved
SHREK
