Access MS Access SQL error

M

mccouch

Joined
Nov 12, 2010
Messages
1
Reaction score
0
Okay, I am trying to create a query that looks simlar to this




My sql statement currently is

SELECT [Inventory Worksheet].F1, [Inventory Worksheet].F2, [Inventory Worksheet].F10, [Inventory Worksheet].F3, [Copy Of Inventory Worksheet].F6, [Copy Of Inventory Worksheet].F7, [F7]-[F6]*[F3] AS Expr1
FROM [Copy Of Inventory Worksheet] INNER JOIN [Inventory Worksheet] ON [Copy Of Inventory Worksheet].F1 = [Inventory Worksheet].F1
ORDER BY [F7]-[F6]*[F3] DESC;


When I try to view the query in datasheet view I get hte following error msg " The specified field F7 could refer to more than one table listed in the FROM clause of your statement..

I am trying to edit my query such that it includes for RawMargins. The function would be F7-F6*F3, but when I use that, I get the error. Help would be lovely


Thanks in advance.
 
Back
Top