Count columns

[Igor G.]

I have table with products data... example:

 

[Rick Brandt]

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!

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.