Try to search your question here, if you can't find : Ask Any Question Now ?

The specified field [Report].[Field] could refer to more than one table listed in the FROM clause of your SQL statement

HomeCategory: stackoverflowThe specified field [Report].[Field] could refer to more than one table listed in the FROM clause of your SQL statement
Avatarrupesh asked 4 months ago

I am creating a report based on a query in Microsoft Access, and I keep receiving an error message when switching from Design View to Report view.

The specified field ‘[Customer Report].[Need Date]’ could refer to more than
one table listed in the FROM clause of your SQL statement.

I have searched through questions that have already been asked, and it seems as though the answer is simple: I just need to specify what table the [Need Date] is coming from in the SQL coding. However, I’ve already done that, and the error message continues to happen. Here is the coding for the query that my report is based on:

SELECT 
    [UID Only].[Our PN], 
    [UID Only].[Customer PN], 
    [UID Only].Description, 
    [UID Only].[Order #], 
    [UID Only].[Customer PO], 
    [UID Only].[Need Date], 
    [Customer Report].[Need Date], 
    [UID Only].[Unique ID]
FROM ([UID Only] 
LEFT JOIN [UID, Date] ON [UID Only].[Unique ID] = [UID, Date].[Unique ID]) 
LEFT JOIN [Customer Report] ON [UID Only].[Unique ID] = [Customer Report].[Unique ID]
WHERE [UID, Date].[Unique ID] Is Null;
1 Answers
Best Answer
AvatarMatthias answered 4 months ago
Your Answer

12 + 13 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com