Change field names in queries?

[Guest]

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.

 

[Guest]

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.

 

[Guest]

great thanks again!

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.

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.