Formatting data in report recordset

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

Guest

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
 
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
 
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
 
You may have to use calculated fields in the query.
For the currency, you may try
Format([CurrFld],"0")
Format([PctFld],"#0%")
 
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

Klatuu said:
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


Chad said:
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
Click to expand...
Click to expand...
 
Back
Top