Change field names in queries?

T

TKM

I have a few Total queries and when I export to Excel they show like this in
the field names.

sumofProcess date
sumofTotals

Is there anyway I can change the names back to the original field names
before or after they export? I want to make sure whena user clicks to see the
updated data that it gets changed everytime the data changes.
 
K

Klatuu

Use calculated fields in your query.
If you are using the query builder, instead of the field name, use this:
ProcessDate: Sum([ProcessDate])
Then put Expression in your Totals row for the field.
 
T

TKM

great thanks again!

Klatuu said:
Use calculated fields in your query.
If you are using the query builder, instead of the field name, use this:
ProcessDate: Sum([ProcessDate])
Then put Expression in your Totals row for the field.


TKM said:
I have a few Total queries and when I export to Excel they show like this in
the field names.

sumofProcess date
sumofTotals

Is there anyway I can change the names back to the original field names
before or after they export? I want to make sure whena user clicks to see the
updated data that it gets changed everytime the data changes.
Click to expand...
Click to expand...
 
Top