Re: Sum field not formatting as currency

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I don't push reports to Excel and if I did, I would probably format the
cells afterward.

--
Duane Hookom
MS Access MVP

"Kathy Webster" <slickdock@xxxxxxxxx> wrote in message
news:oFNZg.15940$UG4.15802@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Well, simple is best. I'm sure there must be a way rather than having to
introduce Word into the picture, just for this one issue of the format of
a sum number.

"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
news:%23JheTFy8GHA.4708@xxxxxxxxxxxxxxxxxxxxxxx
See if this sample solution from A.D. Tejpal meets your needs
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Reports_AccessToExcelAndWord.mdb'.

--
Duane Hookom
MS Access MVP

"Kathy Webster" <slickdock@xxxxxxxxx> wrote in message
news:kfzZg.13135$o71.10018@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Well, I thought it was beautiful, but when it Outputs to Excel, it shows
back up as a number with no decimals and no dollar sign....

"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
news:e4ttWWu8GHA.3620@xxxxxxxxxxxxxxxxxxxxxxx
If the format property is set to currency and it is not showing
currency then try set the control source to:
=Val(sum([Payment]))


--
Duane Hookom
MS Access MVP


"Kathy Webster" <slickdock@xxxxxxxxx> wrote in message
news:QluZg.8806$Lv3.324@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
It is. The format of the text box in the detail as well as the header
are both set to currency.


"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
news:%23oHR$Gu8GHA.2092@xxxxxxxxxxxxxxxxxxxxxxx
Set the Format property of the text box to Currency.

--
Duane Hookom
MS Access MVP

"Kathy Webster" <slickdock@xxxxxxxxx> wrote in message
news:r2uZg.12997$o71.11634@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
This should be so simple. I can't figure out what I'm doing wrong.
I have a currency field in a report's details. I am summing it in
the header:
=sum([Payment])
The format of both is currency.
The details are displaying as currency ($220.00, $25.00) but the
header is displaying as 245.

Whazzup?
TIA,
Kathy
















.

Relevant Pages

  • Re: format in query column no formats in dropdown
    ... Duane Hookom ... >> MS Access MVP ... >>> but the conditional format does not work correctly. ... >>> number format in the query or report. ...
    (microsoft.public.access.queries)
  • Re: Limit Number of Rows Returned
    ... Provate Sub Detail_Format (Cancel as Integer, ... MS Access MVP ... "Duane Hookom" wrote: ... The Expression On Format you entered as the event property setting ...
    (microsoft.public.access.reports)
  • Re: Problem changing format from number to currency
    ... > have based my report on and is the record source of the ... > numbers even though the format of the field is text. ... >>Duane Hookom ... >>> format, currency was listed there. ...
    (microsoft.public.access.reports)
  • Re: Duane Hookom HD - QBF Date ???
    ... Return a delimited string in the date format used ... Duane Hookom wrote: ... MS Access MVP ...
    (microsoft.public.access.forms)
  • Re: Text box that has either No arrow or Up Arrow or Down Arrow in
    ... Did you set the Format property as I suggested? ... MS Access MVP ... "Duane Hookom" wrote: ... I would like to have field to place an arrow in next to the result, ...
    (microsoft.public.access.reports)