Howdy Folks,
Simple circumstance: in a table of values (tblData), I want to be able to generate a recordset that associates each of those values with a tier or grade level (i.e. - 93% = A, so any value >= 93% should be an A, etc).
I'm using a reference table (tblRef) to store [ThresholdValue] (i.e. - 93%) and [TierValue] (i.e. - "A")
Right now my query SQL statement is basically like this:
SELECT [tblData].[Percentage], [tblRef].[ThresholdValue], [tblRef].[Grade] FROM tblData, tblRef WHERE [tblRef].[ThresholdValue]=(SELECT Max([ThresholdValue]) FROM tblRef WHERE [Percentage]>=[ThresholdValue])
The problem is that of the 32 records in tblData, only 24 are returned in the recordset. How/Why are records getting dropped?
Any help greatly appreciated.
TIA,
John
Simple circumstance: in a table of values (tblData), I want to be able to generate a recordset that associates each of those values with a tier or grade level (i.e. - 93% = A, so any value >= 93% should be an A, etc).
I'm using a reference table (tblRef) to store [ThresholdValue] (i.e. - 93%) and [TierValue] (i.e. - "A")
Right now my query SQL statement is basically like this:
SELECT [tblData].[Percentage], [tblRef].[ThresholdValue], [tblRef].[Grade] FROM tblData, tblRef WHERE [tblRef].[ThresholdValue]=(SELECT Max([ThresholdValue]) FROM tblRef WHERE [Percentage]>=[ThresholdValue])
The problem is that of the 32 records in tblData, only 24 are returned in the recordset. How/Why are records getting dropped?
Any help greatly appreciated.
TIA,
John
