Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rename fields/columns?
Message
From
05/05/2004 07:03:29
 
 
To
04/05/2004 14:27:24
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00900867
Message ID:
00901120
Views:
16
You can give the query column an alias name, which would represent that column in an export. In the field name field in the query design window the syntax would be:

AliasName: [TableName]![FieldName]

You can also concatenate fields together this way. For example:

Name: [Employees]![LastName]&", "&[Employees]![FirstName]
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Previous
Reply
Map
View

Click here to load this message in the networking platform