Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / June 2007

Tip: Looking for answers? Try searching our database.

Totals in MS Access 2003 Reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cynthia - 11 Jun 2007 20:21 GMT
I need to the following types of totals for a report and hours of
trying different ways are not working:

I want to report totals for:

-Count of number of dates in a field (some empty fields) as well as
-Count in field containing numbers but only want to count # of
populated fields
-Count of Yes in Yes/No fields

Is there a way to total for absolute value?

Thanks.
cynthia - 11 Jun 2007 21:45 GMT
By doing a search here, I found the answer to the Y/N sum question.
Worked like a charm! Still looking for the others!

> I need to the following types of totals for a report and hours of

> -Count of Yes in Yes/No fields

> Thanks.
cynthia - 12 Jun 2007 23:22 GMT
I have resolved all these issues. Once I found out how to sum Y/N
checkboxes, the others seem to fall into place. I even figured out how
to make a field total in absolute values. If you want to know, write
me!
 
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.