Count columns

  • Thread starter Thread starter Igor G.
  • Start date Start date
Igor said:
I have table with products data... example:
---------------------------------------------------------------------
Date Time Data1 Data2 Data3 Data4 ...
---------------------------------------------------------------------
28.07.2008 08:00 2 8 4 5
...
29.07.2008 08:00 1 3 2 1
...
29.07.2008 10:00 9 6 8 8
...
30.07.2008 17:15 0 7 4 7
...
---------------------------------------------------------------------
COUNT: 12 23 16 21
...

Hew to create query for count records in columns, like in example?
Thanks!
Click to expand...

First, those are "sums", not "counts" (though a couple of them in your
example are incorrect).

Second, you would not do that in a query, you would do it in a report by
using...

=Sum(Data1)
=Sum(Data2)
etc..

in the ReportFooter.
 

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

How to Populate Data from a table to another 0
Group by and count queries 1
Counting number of items excluding duplicates. 1
Access Dcount (multiple criteria) 3
Count based on multiple fields 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
PUT TOTAL AT THE END OF A COUNT QUERY 3

Back
Top