A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sorting data with query



 
 
Thread Tools Display Modes
  #1  
Old July 7th, 2009, 04:08 PM posted to microsoft.public.access.queries
frogstyle
external usenet poster
 
Posts: 5
Default 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  
Old July 7th, 2009, 04:54 PM posted to microsoft.public.access.queries
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old July 7th, 2009, 05:39 PM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old July 7th, 2009, 06:39 PM posted to microsoft.public.access.queries
frogstyle
external usenet poster
 
Posts: 5
Default 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  
Old July 10th, 2009, 02:52 AM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.