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 / March 2008

Tip: Looking for answers? Try searching our database.

Sum Function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lmossolle - 19 Mar 2008 19:01 GMT
I am having a brain freeze, I need a sum of a field where a name = Carla
could someone please assist?

=Sum [SCD the table] [Assigned fieldname] = Carla

Thanks
Evi - 20 Mar 2008 14:48 GMT
In case Carla isn't the only name you will ever want to Sum by, what about
using the SortingGrouping box to sort by your PersonsName field, giving it a
Footer and then you can have a Sum in the Group Footer.
Or you can do the summing in a Totals query grouped by name and put the
results as a Subreport in a Report's Footer

You could also use the  DSum Function (if Carla really is the only person
being summed)
Evi

> I am having a brain freeze, I need a sum of a field where a name = Carla
> could someone please assist?
>
> =Sum [SCD the table] [Assigned fieldname] = Carla
>
> Thanks
 
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.