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?
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.
See all Topics access
<Doug Klippert@ 3:10 AM
Comments: Post a Comment