If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Same field name in two tables
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 |
#2
|
|||
|
|||
Same field name in two tables
Qualify it with the table name:
Left([TheTableNameGoesHere].[ACCT_NBR] ,3) Ken Sheridan Stafford, England cluckers wrote: 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 -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Same field name in two tables
Cluckers -
Try this (using your table name): Left([tablename]![ACCT_NBR] ,3) -- Daryl S "cluckers" wrote: 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 |
#4
|
|||
|
|||
Same field name in two tables
=?Utf-8?B?RGFyeWwgUw==?= wrote in
: Try this (using your table name): Left([tablename]![ACCT_NBR] ,3) Uh, I think that should be a period instead of an exclamation point. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|