Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to display this
- Thread starter Machlink
- Start date
I always recommend you never view a table. You always view things via views - normally queries in Jet. One of the ideas of views is you can make the underlying data more user-friendly. Changing the name is just one example.
Create a query in the QBE query grid. Remove the field administration and add another one admin:[administration]. This will now display (and update) administration but with the name admin. Look at the SQL and you will see it now says [administration] AS admin.
Create a query in the QBE query grid. Remove the field administration and add another one admin:[administration]. This will now display (and update) administration but with the name admin. Look at the SQL and you will see it now says [administration] AS admin.
- Status
Similar threads
- Locked
- Question
- Locked
- Question