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 / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

sum an expression in a query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CharlieG - 03 Oct 2004 02:03 GMT
I have created an expresssion in a query that converts hours and minutes to
decimal times.  I would like to add the total decimal times for a month in my
report but I keep getting a message that the expression is too complex.  I
have tried using the "sum" operator in the query but then I get the same
message.  Anyone know how I can add the column in the report?  Putting sum in
the totals column in the Query doesn't work either.
Duane Hookom - 04 Oct 2004 05:05 GMT
Maybe you could share the "expression".

Signature

Duane Hookom
MS Access MVP

> I have created an expresssion in a query that converts hours and minutes to
> decimal times.  I would like to add the total decimal times for a month in my
> report but I keep getting a message that the expression is too complex.  I
> have tried using the "sum" operator in the query but then I get the same
> message.  Anyone know how I can add the column in the report?  Putting sum in
> the totals column in the Query doesn't work either.
 
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.