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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DSUM Problem

Status
Not open for further replies.
Chance1234

Chance1234

IS-IT--Management
Jul 25, 2001
7,871
US
cant for the life of me work out what i am doing wrong here
here is my Dsum formula

=DSum("[Amount]","qryINVOICESforreport","[Type]"='Reconnections')
 
Sort by date Sort by votes
Try this:

=DSum("[Amount]","qryINVOICESforreport","[Type] ='Reconnections'") Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
385
soloracer
soloracer
Kennelbloke
  • Locked
  • Question
Problems with image on report 1
Replies
8
Views
282
dhookom
dhookom
lameid
  • Locked
  • Question
The Never shrinking whitespace problem 1
Replies
6
Views
171
lameid
lameid
Lhuffst
  • Locked
  • Question
problem passing dates
Replies
2
Views
109
Lhuffst
Lhuffst
Lhuffst
  • Locked
  • Question
problem assigning value to text box in report on open
Replies
1
Views
85
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top