If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting data with query
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" |
#2
|
|||
|
|||
Sorting data with query
It all starts with the data (not the forms).
What is the data (i.e. 'table') structure? Regards Jeff Boyce Microsoft Office/Access MVP "frogstyle" wrote in message news 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" |
#3
|
|||
|
|||
Sorting data with query
On Tue, 7 Jul 2009 08:08:02 -0700, frogstyle
wrote: 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Sorting data with query
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" wrote: On Tue, 7 Jul 2009 08:08:02 -0700, frogstyle wrote: 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. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Sorting data with query
On Tue, 7 Jul 2009 10:39:02 -0700, frogstyle
wrote: 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. 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" wrote: On Tue, 7 Jul 2009 08:08:02 -0700, frogstyle wrote: 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. -- John W. Vinson [MVP] -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|