Change field names in queries?

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

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.
 
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.
 
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...
 
Back
Top