Administrator
administrator at it.glasgow.gov.uk
Wed Jan 29 03:18:44 CST 2003
Drew -- thanks -- I knew that. Frankly, I can't remember now why I asked the question. Susan H. 0 > This is just a guess, but I would say that you would refer to it with the > table and field name. > > When you build an SQL string, You can just use field names, like this: > > Select FirstName, LastName > >From tblEmployees > > However, you'll notice that Access won't build a query like that. Instead > you'll get this from Access: > > Select tblEmployees.FirstName, tblEmployees.LastName > >From tblEmployees; > > Okay, just tested it. When you don't have a duplicate, you refer to the > field in the recordset as just the field name. When you DO have a > duplicate, I guessed right, you refer to it as tblTable.fldField. > > Drew > > -----Original Message----- > From: Susan Harkins [mailto:harkins at iglou.com] > Sent: Sunday, January 26, 2003 5:30 PM > To: AccessD at databaseadvisors.com > Subject: [AccessD] internal recordset field names > > > Suppose two tables contain the same field name and you base a recordset on > those two tables and include both fields -- how does the recordset name (or > identify) the two fields? I know I can use As to alias them both, but how > would I refer to these fields within the recordset if I didn't? > > Susan H. > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd