Count query

[jamccarley]

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

 

[Duane Hookom]

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?

 

[jamccarley]

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

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

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

 

[Duane Hookom]

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

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

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

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