Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Expresions 1

Status
Not open for further replies.
jay2502

jay2502

Technical User
Apr 20, 2007
25
A2
I have a report and it has a list of figures which I need a total for. I tried to build an expression that says =sum(field) in the query builder but it only returns the first amount.
 
Sort by date Sort by votes
Did you enter it in the footer section or the details section? In a text box of the footer, it should run a total for that field in the detail section.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
896
hermanlaksko
hermanlaksko
Moss100
  • Locked
  • Question
Updating Outlook Contacts from Access
Replies
0
Views
352
Moss100
Moss100
DBDivaAuto
  • Locked
  • Question
Breaking the VBA Password in Access
Replies
3
Views
428
Andrzejek
Andrzejek
osera
  • Locked
  • Question
Delete file from Sharepoint with Access VBA
Replies
2
Views
513
osera
osera
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
576
feipezi
feipezi

Part and Inventory Search

Sponsor

Back
Top