Field Display Question

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

Guest

How do I add a "$" in front of the following field's result?

Control Source Code: =Sum(IIf([Project Type]="Soccer",[Payment for
Allocation],Null))

Thanks,
Adam
 
Got it! Thanks!

Duane Hookom said:
Try set the format property to Currency.

--
Duane Hookom
MS Access MVP

AdamZ said:
How do I add a "$" in front of the following field's result?

Control Source Code: =Sum(IIf([Project Type]="Soccer",[Payment for
Allocation],Null))

Thanks,
Adam
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Question 1
Sum a field with null value 5
Passing data from a form to report field 4
"0" in a sum calculation not showing up? 1
Errors in Report total fields 19
Calculate between SubReport and Report 1
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
"#Num!" Error display as "-"? 1

Back
Top