Report Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please help me with what is likely a very elementary expression? I would be so appreciative!

Sum RegistrationFee if FeeDescription equals "FullFee"

Karen
 
The SQL for your query would look like:

SELECT Sum(RegistrationFee)
FROM MyTable
WHERE FeeDescription = "FullFee"

To create this through the query interface, select your table and drag both
RegistrationFee and FeeDescription into the grid. Change the query into a
Totals query (it's a choice on the View menu, or you can select the Sigma
icon from the tool bar). When you do that, a new row appears in the grid
labelled "Total", with both cells set to Group By by default. Change the
Group By to Sum under Registration Fee, and to Where under FeeDescription.
Type "FullFee" as the criteria under FeeDescription.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Kharndt said:
Can someone please help me with what is likely a very elementary
Click to expand...
expression? I would be so appreciative!
 
WHERE?

In a control in a Group Footer on a report?

Set the control's source to

=Sum(IIF([FeeDescription = "FullFee",RegistrationFee,0))

If elsewhere or the above doesn't work, please post back with more detail.
 
Back
Top