A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Alias



 
 
Thread Tools Display Modes
  #1  
Old July 11th, 2008, 07:54 PM posted to microsoft.public.access.queries
Dominick D.
external usenet poster
 
Posts: 19
Default Alias

Hi, Guru's...I've been asked to create a table, in which several fields
contain aliases. Now, how do you code a fieldname to be an alias? Is it like
this:

[alias name]: field name

Like that? Thanks.
  #2  
Old July 11th, 2008, 08:48 PM posted to microsoft.public.access.queries
Ryan
external usenet poster
 
Posts: 551
Default Alias

Alias Name: field name will work in a query
no need for the [ ] around the alias name
Or you could just change the name of the field label on the form. If your
users have access to the tables, however, the will see the actual field name.

--
Please remember to mark this post as answered if this solves your problem.


"Dominick D." wrote:

Hi, Guru's...I've been asked to create a table, in which several fields
contain aliases. Now, how do you code a fieldname to be an alias? Is it like
this:

[alias name]: field name

Like that? Thanks.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.