I did a table analysis on mt vendor table. I would like to know what or if the xyz_ is needed and if so for what reason .<br><br>SELECT [ID] AS xyz_ID_xyz, [Vendor] AS xyz_DispExpr_xyz, [Vendor] <br>FROM [TblVendor] ORDER BY [Vendor]<br><br> Is the xyz_ just something access just puts there.<br><br> <p>Thanks In Advance.<br><a href=mailto: > </a><br><a href= > </a><br>
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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Analyze Table
- Thread starter merlin72
- Start date
jimmythegeek
Programmer
I have no idea why the xyz is there, but you certainly DO NOT need it.<br><br>I have never used the table analyzer, so I don't know if it is something Access does automatically, but Access tends to have some overkill on some of the wizards it has. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href= Application Development
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question