Format a calculated field from query on report??

[Guest]

Hello

I have a report whose record source is a query. On the query, I added some calculated fields (i.e total/hr) to the detail section. On the report, I tried formatting the calculated fields, without success. Actually, there were no options for the Format field. So, I decided to get rid of the calculated fields from the query and create new ones on the report itself - this at least let me format the calculated field. However, I now want to avg. one of the calculated fields for the month - in the footer section, but I couldn't view the results - I would get an error box prompting me for total/hr.

Is there a way to format the original calculated field from the query or do I need to create it on the report? And, how would I find the avg of that calculated field? Any suggestions

Thanks
Carri

 

[Guest]

Carrie,
Create a simple query based on your calculated query and
then have the report reference the simple query. You
should be able to format and average the data at this
point.
Chris

-----Original Message-----
Hello,

I have a report whose record source is a query. On the

query, I added some calculated fields (i.e total/hr) to
the detail section. On the report, I tried formatting the
calculated fields, without success. Actually, there were
no options for the Format field. So, I decided to get rid
of the calculated fields from the query and create new
ones on the report itself - this at least let me format
the calculated field. However, I now want to avg. one of
the calculated fields for the month - in the footer
section, but I couldn't view the results - I would get an
error box prompting me for total/hr.

Is there a way to format the original calculated field

from the query or do I need to create it on the report?
And, how would I find the avg of that calculated field?
Any suggestions?

 

[Chris Sergent]

Have you tried grouping in the query. If you have multiple
months in the query, you could group there. If the month
is coming out in the format that you need, then try this:

1.Do not format the data in the query. Format it in the
report.

2.Add a group to your report for months and include a
group header. Place the month in the group header and then
place the employees in the detail section. This should
give you only one month and a heading for each.

If this is still off key, do you have a screen print or a
web site that you could throw a pdf on. I have to work
with monthly data regularly, so if need be we can work
backwards.

Chris

-----Original Message-----
Thank you for the suggestion, but I still cannot format

the calculated fields. I must be doing something wrong.