NEWBIE - confused as to how to configure query structure

SHREK288

New member
Local time
Today, 23:03
Joined
Jun 16, 2011
Messages
7
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 :(
 
The first suggestion is to post enough specific information for someone to be able help you.

What are the tables and column names. What does your attempted SQL look like?
 

Users who are viewing this thread

Back
Top Bottom