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
|
|||
|
|||
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 |
#2
|
|||
|
|||
Count query
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 |
#3
|
|||
|
|||
Count query
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 |
#4
|
|||
|
|||
Count query
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 |
Thread Tools | |
Display Modes | |
|
|