I rarely if ever format a value in a query. If you want a number, leave it a
number and provide the formatting in your text box on your report. Queries
columns shouldn't be formatted unless the results are pushed to another
system that requires a formatted value.
--
Duane Hookom
Microsoft Access MVP
"Tyler at Creme" wrote:
[Quoted Text] > I am using the following formula in a query to give a percentage of column B
> as a whole of column A:
>
> ItoT:
> Format(Round(Sum([Weekly_Data_Query]![Tours])/Sum([Weekly_Data_Query]![Inquiries]),2),"Percent")
>
> It seems to look okay in a report give 20 different customer rows, but I
> want to have an average of all customers at the end of each month on the
> report.
>
> What kind of box and formula will give me this, because the format ribbon
> only allows me to count values for this calculated query field?
>
> --
> Tyler at Creme
> New Access User
|