Renaming Fields in a Query

J

Jill

I have to rename the fields to the next week. The queries are based off of
Crosstab queries. They have formulas in them that need to be updated as well.
 
K

Klatuu

Your question is a little unclear, but I think this will get you what you want.
In the Field row of the Column in the query you want to change you put the
name you want followed by a colon, followed by the actual field name or the
value you want to create.
For example, lets say you have a field in the table (or query) your query is
based on called Bungo, but in the results of the query, you want then name to
be Foo:

Field: Foo: Bungo
 
Top