Count query

How would I set up this query? All I want to do is count the number of errors
on a certain cell in our machining process. I have a [Date] field, [Cell 1],
[Cell 2] all the way through [Cell 7]. I want a daily number of errors and
then an accumulitive number every day. I am then going to have it graph this
data.

Thanks
Joshua McCarley

Are you sure you want to count them rather than sum them? If you actually
have field names like [Cell 1], [Cell 2],... you might consider normalizing
your table structure.

Can you provide some sample records and how you would like them to appear in
a query?

--
Duane Hookom
Microsoft Access MVP


"jamccarley" wrote:

How would I set up this query? All I want to do is count the number of errors
on a certain cell in our machining process. I have a [Date] field, [Cell 1],
[Cell 2] all the way through [Cell 7]. I want a daily number of errors and
then an accumulitive number every day. I am then going to have it graph this
data.

Thanks
Joshua McCarley

I have tried two different versions. I set up just a "Cell" field and put the
cell number in it, but when I use sum it adds the cell number together. I
then set up 7 different yes no fields for them to pick the cell number. I
have the query to where it counts the errors, but not where it gives an
accumulative total every day




"Duane Hookom" wrote:

Are you sure you want to count them rather than sum them? If you actually
have field names like [Cell 1], [Cell 2],... you might consider normalizing
your table structure.

Can you provide some sample records and how you would like them to appear in
a query?

--
Duane Hookom
Microsoft Access MVP


"jamccarley" wrote:

How would I set up this query? All I want to do is count the number of errors
on a certain cell in our machining process. I have a [Date] field, [Cell 1],
[Cell 2] all the way through [Cell 7]. I want a daily number of errors and
then an accumulitive number every day. I am then going to have it graph this
data.

Thanks
Joshua McCarley

IMO, I would not use 7 different yes/no fields. The Cell value should be
selected from a drop down in a single field.

If your table structure is correct, you should only need a totals query to
count the records and group by the Cell field.

--
Duane Hookom
MS Access MVP


"jamccarley" wrote in message
...
I have tried two different versions. I set up just a "Cell" field and put
the
cell number in it, but when I use sum it adds the cell number together. I
then set up 7 different yes no fields for them to pick the cell number. I
have the query to where it counts the errors, but not where it gives an
accumulative total every day




"Duane Hookom" wrote:

Are you sure you want to count them rather than sum them? If you actually
have field names like [Cell 1], [Cell 2],... you might consider
normalizing
your table structure.

Can you provide some sample records and how you would like them to appear
in
a query?

--
Duane Hookom
Microsoft Access MVP


"jamccarley" wrote:

How would I set up this query? All I want to do is count the number of
errors
on a certain cell in our machining process. I have a [Date] field,
[Cell 1],
[Cell 2] all the way through [Cell 7]. I want a daily number of errors
and
then an accumulitive number every day. I am then going to have it graph
this
data.

Thanks
Joshua McCarley