Circular Reference ?

[essnrv]

Hi All,
Please Help me in fixing below Query

Insert Into [Inventory Physical Count] Select [Batch Number] ,[Page Number],[Line Number],
[Item Number],[Description],[Unit of Measure],[Location],[Bin],[Physical Count]
From [Physical Count Temp]
Where [Physical Count Temp].[Batch Number]= 2

I am getting Circular Reference Caused by alias
'Batch Number' in query definition's SELECT List.


Thanks in advance

 

[m6]

Dear essnvr,

Try putting the table name in front of you select field names.

Insert Into [Inventory Physical Count] Select [Physical Count Temp]![Batch Number] ,[Physical Count Temp]![Page Number],[Physical Count Temp]![Line Number],
[Physical Count Temp]![Item Number],[Physical Count Temp]![Description],[Physical Count Temp]![Unit of Measure],[Physical Count Temp]![Location],[Physical Count Temp]![Bin],[Physical Count Temp]![Physical Count]
From [Physical Count Temp]
Where [Physical Count Temp].[Batch Number]= 2

Good Luck!
m6