Renaming Fields in a Query

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

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Renaming tables 6
Crosstab with subquery as source to another query 5
Counting multiple memberships 1
access reports 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Howto move a query into a temp table that would be named by user 1
query parameter in vba 4
Sum of a field from Crosstab Query 2

Back
Top