Aliases !!!

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

Guest

Is somebody can tell me something about Aliases.
I read that this works only in .ADP files but I can't even make .ADP file .
Please somebody help me with this.
 
Create a query, with a field show in the grid.

Now type a name in front of the field name, followed by a colon. For
example, if the field is called:
ID
type:
ShowThisName: ID

ShowThisName is the alias for the field. If you now build a form or report
using this query, you will find that the form/report knows the field by its
alias, not by the original field name (ID in the example.)

You can also right-click the table in the upper pane of query design, and
choose Properties. The first property lets you set an alias for the table
name.

If you switch the query to SQL View (View menu), you will see AS in front of
the alias.
 
Back
Top