 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2008Count columns
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! > I have table with products data... example: > --------------------------------------------------------------------- [quoted text clipped - 14 lines] > 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.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.