[AccessD] Message not deliverable

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