I am using a query to conduct a simple calculation from my tables. Here is SQL statement:
Code:
SELECT [tbl_Cell].[TargetSkids]*[tbl_Cell].[Canisters_Skid]*[tbl_DataEntry].[DownTime] AS CansLost
FROM tbl_Cell, tbl_DataEntry;
The query should only be returning 9 records. But for whatever reason I get over 60 results. Mixed in there is the correct values I seek, but I am not sure where these other numbers are originating from. Here is some screenshots to help you, reader, better understand my problem.
First part, should be multiplying these two columns by this one >
My query then looks likes this below. The highlighted records are actual correct values, the rest are 'extras'.