Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Sunday, October 01, 2017 – Permalink –

Use a Table Alias

to change names in a query

When you need to change the table name referenced in an existing Access query, it can be a pain. This is especially true if the query contains a large number of fields.

You typically might use an alias when you need to relate a table to itself or tables have long or unwieldy names.

If you make a practice of always using aliases in your queries, you can easily change which table is used by changing the one occurrence of the original table name in the query's FROM clause.

To set a table alias in the query's Design view,

Right-click on the table field list and choose Properties.

Then, enter the alias name you want to use in the Alias text box.

See all Topics access
Labels: Reference, Shortcuts, Tables, Tips, Tutorials

<Doug Klippert@ 3:10 AM

Comments: Post a Comment