Formatting data in report recordset

[Chad]

I have a SQL statement in a report that I would like to change the default
formats of the data that is output. I am able to successfully accomplish
this by changing the field properties, but when I save and close out of me
report, the field properties revert back to normal. Is there something I am
missing?

Thanks,
Chad Lucy

 

[Klatuu]

The formatting should be done in the report, not in the the query.

 

[Chad]

Thanks for the response...maybe you can help me out. The query that I am
formatting actually populates a chart and I would like to format the data
within the data table of the graph. The only way that I am able to figure
out how to do it is to format the data in the datasheet of the chart but
unfortunately, when I close out, the formatting changes do not stay.

Any suggestions?

Thanks,
Chad

 

[Klatuu]

What kind of formatting are you wanting to do on the data?

 

[Chad]

All of the data that is being returned is in the general format. I would
like to return either %'s or currency with 0 decimals.

Thanks again,
Chad

 

[Klatuu]

You may have to use calculated fields in the query.
For the currency, you may try
Format([CurrFld],"0")
Format([PctFld],"#0%")

 

[Chad]

Thanks, that is exactly what I was looking for. Also, in case someone else
is looking for the same thing, I came across this thread that solved my
problem another way:

http://www.access-programmers.co.uk/forums/showthread.php?t=67616

Thanks again!

Chad

You may have to use calculated fields in the query.
For the currency, you may try
Format([CurrFld],"0")
Format([PctFld],"#0%")
--
Dave Hargis, Microsoft Access MVP

All of the data that is being returned is in the general format. I would
like to return either %'s or currency with 0 decimals.

Thanks again,
Chad