Sorting data with query

[frogstyle]

First let me start by apologizing... If this question has already been
answered, I don't know where to look for it. I went through several pages of
posts but I didn't see an answer.

My question is this:

I have a database that was created by some other company. It was built
using Access 97. It is a very complicated database (at least for me) but I
have figured out how to access the data I need. What I am trying to do with
it now, I can't figure out on my own.

The data I collect is entered in a form that allows me to enter information
from cards that inclue "Employee", "Shift", "Date" and "Work Area"
How can I create a query so I can get a total of "How many cards were turned
in" and then seperate how many were turned in on each shift in each work area.
For example I want to know how many were turned in on "Shift 1, Work Area 2"

 

[Jeff Boyce]

It all starts with the data (not the forms).

What is the data (i.e. 'table') structure?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

First let me start by apologizing... If this question has already been
answered, I don't know where to look for it. I went through several pages of
posts but I didn't see an answer.

My question is this:

I have a database that was created by some other company. It was built
using Access 97. It is a very complicated database (at least for me) but I
have figured out how to access the data I need. What I am trying to do with
it now, I can't figure out on my own.

The data I collect is entered in a form that allows me to enter information
from cards that inclue "Employee", "Shift", "Date" and "Work Area"
How can I create a query so I can get a total of "How many cards were turned
in" and then seperate how many were turned in on each shift in each work area.
For example I want to know how many were turned in on "Shift 1, Work Area 2"

You'ld create a Totals query based on the table.

If you would like help doing so please post a description of the table
structure.

 

[frogstyle]

I'm not sure what is meant when asked for the "table structure"

I'll give it my best description

The data comes from two separate tables (tblDemoVarType, tblDemoVarValue)
tblDemoVarType has the following columns
Demo Var Type ID; Demo Var Name; Data Type; Check List Type ID; Last Value
tblDemoVarValue has the following columns
Demo Var Value ID; Demo Var Value; Demo Var Type ID

I don't know if this helps. If you can be specific as to what will help you
help me, please do. Thanks!

 

[John W. Vinson]

On Tue, 7 Jul 2009 10:39:02 -0700, frogstyle

It's not at all clear to me where in your tables you can find the information
that a workshift was on Shift 1 or in Work Area 2. I really have to wonder
whether these tables are normalized at all!!! What are the values of "Demo Var
Name" and so on? What is "Last Value"?

If you're doing a timecards database I would expect tables such as:

Employees
EmployeeID
LastName
FirstName
JobCode
<maybe other biographical data>

Jobcodes
JobCode <primary key>
JobDescription

Areas
AreaID
Description

Workshifts
EmployeeID
AreaID
StartDateTime
EndDateTime

There may be tables for shifts as well.