Redberry95
New member
- Local time
- Today, 02:17
- Joined
- Oct 18, 2019
- Messages
- 2
Hi all,
Hopefully someone is able to help me, as I have a fairly limited Access knowledge
What I am trying to do, is take a series of text strings which indicate the grade variant of a specific car make and model (e.g. SPORTBACK TFSI S LINE, TDI S, TDI SE) and then assign a level to each variant.
I have used the below query to do this by saying where Marque = X, Range = Y and Variant Name is like the variant name given (Using *) (I.E. Pulls out 'S LINE' from 'SPORTBACK TFSI S LINE'
LEFT JOIN tbl_Gradelevel ON (tbl_MASTERGRADE.Variant_Name Like '*' & tbl_Gradelevel.Grade& '*') AND (tbl_MASTERGRADE.Range = tbl_Gradelevel.Model) AND (tbl_MASTERGRADE.Marque = tbl_Gradelevel.Brand);
This is successful in working where the grades are clearly different, E.G. Ultimate, Tekna etc.
However where the grades are very similar it gets confused as I assume by using Wildcards *S* is the same as *SE*
Does anyone have a fairly simple solution that would help to differentiate the names which are confusing my query
Many thanks
Hopefully someone is able to help me, as I have a fairly limited Access knowledge
What I am trying to do, is take a series of text strings which indicate the grade variant of a specific car make and model (e.g. SPORTBACK TFSI S LINE, TDI S, TDI SE) and then assign a level to each variant.
I have used the below query to do this by saying where Marque = X, Range = Y and Variant Name is like the variant name given (Using *) (I.E. Pulls out 'S LINE' from 'SPORTBACK TFSI S LINE'
LEFT JOIN tbl_Gradelevel ON (tbl_MASTERGRADE.Variant_Name Like '*' & tbl_Gradelevel.Grade& '*') AND (tbl_MASTERGRADE.Range = tbl_Gradelevel.Model) AND (tbl_MASTERGRADE.Marque = tbl_Gradelevel.Brand);
This is successful in working where the grades are clearly different, E.G. Ultimate, Tekna etc.
However where the grades are very similar it gets confused as I assume by using Wildcards *S* is the same as *SE*
Does anyone have a fairly simple solution that would help to differentiate the names which are confusing my query
Many thanks