Help with sql query

[andyL]

I have a ADODB app with an Access database which I record the
productivity evaluations of personnel for each job, each job has a
table in the database (5 jobs) job1, job2, job3, job4, job5 also
exists 2 tables which the one has all the names of workers (names) and
the other all the dates (dates) where became a at least one
registration for somebody job
job1-5 -- Name (char), date(short date), totalW (number), totalT
(number).
Names --name (char)
Date --Date (short date)
I would want to make a recordset (SQL query) in which it will have all
the names from names and for every date in Dates table to imports the
values totalW , totalT for every job. If some date has not become for
example the job1 but has become the job2 it places value 0 in jobs1
field
Something like this.
Name(char),date(short date),job1W(number),job1T(number),
job2W(number),job2T(number) , job2W(number),job2T(number)…etc
is that possible??

 

[andyL]

any help?

 

[Duane Hookom]

Do you have 5 job tables? Normalization would suggest not storing data in
field or table names. I would think this should be one table. Also, field
names like "Name" and "Date" are reserved words and should be replaced by
something a little more descriptive. Also, you should consider storing first
and last names in separate fields.

I'm sorry but the majority of your question is difficult to understand.
Perhaps you could type a few sample records and what you expect from the
query.