Same field name in two tables

[cluckers]

I am running a query that utilizes two joined table. One of the fields for my
query is Left([ACCT_NBR] ,3) AS Prefix. The problem is that both tables
have a field called [ACCT_NBR]. How do I designate which table it is coming
from. thanks

 

[KenSheridan via AccessMonster.com]

Qualify it with the table name:

Left([TheTableNameGoesHere].[ACCT_NBR] ,3)

Ken Sheridan
Stafford, England

I am running a query that utilizes two joined table. One of the fields for my
query is Left([ACCT_NBR] ,3) AS Prefix. The problem is that both tables
have a field called [ACCT_NBR]. How do I designate which table it is coming
from. thanks

 

[Daryl S]

Cluckers -

Try this (using your table name):

Left([tablename]![ACCT_NBR] ,3)

 

[David W. Fenton]

Try this (using your table name):

Left([tablename]![ACCT_NBR] ,3)

Uh, I think that should be a period instead of an exclamation point.