Cameo plz reply or anyone...thank you

N

Nadia

If it's possible, I'd like my output to display:

The field "InspEmployee" for each inspector's id number
followed by the field "InspDate" showing each date only
once, followed by an average number of units scaned for
that particular day.

Does that help?
I appreciate your help and reply.

~Nadia (plz feel free to e-mail me privately if you want
or it's ok to continue posting on here)
-----Original Message-----
It sounds like you need a Crosstab query. I can't visualize your output from
your description below. If you can mock up a sample of what your output
should look like, I think I can help. Please post to group not to me.

Cameo

Here a little background on what this database is based
upon. There are inspectors (who each have an employee id
number) who work out in the field inspecting ground
mounted equipment (which each piece of equipment has a
unit number tag). The inspectors use a scanning device in
order to scan barcodes representing codes that describe
what the inspector found was wrong with a particular
unit. Each inspector's scans are downloaded at the end of
their work day and the scans that they made are uploaded
to my table [99 Inspections Table]. The date and time of
each scan (may even be more than one scan code per unit)
are recorded as well.

I have a table with the following fields:

"InspID":primary key:assigns a unique auto number to each
record

"InspUnitID":has a unit number in it that appears like
76U1234

"InspEmployee":has the an employee id such as 22345

"InspDate":tracks the actual date the employee entered data
(inspections)

"InspTime":tracks the actual time the employee entered data
(inspections)

Now what i need to do is determine the average daily
number of inspections of units done by each individual
employee. Even if there's someway I can break down my
data to show me how many units were inspected each day by
an employee that would be a start. Once this is
obtainable I need to compile a group average as well.

If any one has any suggestions or ideas they are much
appreciated. I'm lost completely at what direction to
take here. Not sure if I should be working in SQL or if
there's a query I can design some how. I'm not a complete
whiz at all this so any help is much appreciated.

Thanks much in advance!

~Nadia
 
P

Phobos

SELECT InspEmployee, InspDate, Count([InspEmployee])
FROM YourTable
GROUP BY InspEmployee, InspDate;


Try the above query, it will only work if the Date field contains a date
only and not a date/time combination.

P


Nadia said:
If it's possible, I'd like my output to display:

The field "InspEmployee" for each inspector's id number
followed by the field "InspDate" showing each date only
once, followed by an average number of units scaned for
that particular day.

Does that help?
I appreciate your help and reply.

~Nadia (plz feel free to e-mail me privately if you want
or it's ok to continue posting on here)
-----Original Message-----
It sounds like you need a Crosstab query. I can't visualize your output from
your description below. If you can mock up a sample of what your output
should look like, I think I can help. Please post to group not to me.

Cameo

Here a little background on what this database is based
upon. There are inspectors (who each have an employee id
number) who work out in the field inspecting ground
mounted equipment (which each piece of equipment has a
unit number tag). The inspectors use a scanning device in
order to scan barcodes representing codes that describe
what the inspector found was wrong with a particular
unit. Each inspector's scans are downloaded at the end of
their work day and the scans that they made are uploaded
to my table [99 Inspections Table]. The date and time of
each scan (may even be more than one scan code per unit)
are recorded as well.

I have a table with the following fields:

"InspID":primary key:assigns a unique auto number to each
record

"InspUnitID":has a unit number in it that appears like
76U1234

"InspEmployee":has the an employee id such as 22345

"InspDate":tracks the actual date the employee entered data
(inspections)

"InspTime":tracks the actual time the employee entered data
(inspections)

Now what i need to do is determine the average daily
number of inspections of units done by each individual
employee. Even if there's someway I can break down my
data to show me how many units were inspected each day by
an employee that would be a start. Once this is
obtainable I need to compile a group average as well.

If any one has any suggestions or ideas they are much
appreciated. I'm lost completely at what direction to
take here. Not sure if I should be working in SQL or if
there's a query I can design some how. I'm not a complete
whiz at all this so any help is much appreciated.

Thanks much in advance!

~Nadia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top