My SQL is
Code:
SELECT [Existing Metallurgy].[ID], [Existing Metallurgy].[Metal], [Existing Metallurgy].[Fe], [Existing Metallurgy].[B], [Existing Metallurgy].[C], [Existing Metallurgy].[Co], [Existing Metallurgy].[Cu], [Existing Metallurgy].[Cr], [Existing Metallurgy].[Mn], [Existing Metallurgy].[Mo], [Existing Metallurgy].[Nb], [Existing Metallurgy].[Ni], [Existing Metallurgy].[Si], [Existing Metallurgy].[V], [Existing Metallurgy].[W], [Existing Metallurgy].[Zn], [Existing Metallurgy].[Pb], [Existing Metallurgy].[Al], [Existing Metallurgy].[Sn]FROM [Existing Metallurgy]
WHERE ((([Existing Metallurgy].[Fe]) Between ([forms]![Input form]![Fe]*0.95) And ([Forms]![Input form]![Fe]*1.05))) OR ((([Existing Metallurgy].[B]) Between ([forms]![Input form]![B]*0.95) And ([Forms]![Input form]![B]*1.05))) OR ((([Existing Metallurgy].[C]) Between ([forms]![Input form]![C]*0.95) And ([Forms]![Input form]![C]*1.05))) OR ((([Existing Metallurgy].[Co]) Between ([forms]![Input form]![Co]*0.95) And ([Forms]![Input form]![Co]*1.05))) OR ((([Existing Metallurgy].[Cu]) Between ([forms]![Input form]![Cu]*0.95) And ([Forms]![Input form]![Cu]*1.05))) OR ((([Existing Metallurgy].[Cr]) Between ([forms]![Input form]![Cr]*0.95) And ([Forms]![Input form]![Cr]*1.05))) OR ((([Existing Metallurgy].[Mn]) Between ([forms]![Input form]![Mn]*0.95) And ([Forms]![Input form]![Mn]*1.05))) OR ((([Existing Metallurgy].[Mo]) Between ([forms]![Input form]![Mo]*0.95) And ([Forms]![Input form]![Mo]*1.05))) OR ((([Existing Metallurgy].[Nb]) Between ([forms]![Input form]![Nb]*0.95) And ([Forms]![Input form]![Nb]*1.05))) OR ((([Existing Metallurgy].[Ni]) Between ([forms]![Input form]![Ni]*0.95) And ([Forms]![Input form]![Ni]*1.05))) OR ((([Existing Metallurgy].[Si]) Between ([forms]![Input form]![Si]*0.95) And ([Forms]![Input form]![Si]*1.05))) OR ((([Existing Metallurgy].[V]) Between ([forms]![Input form]![V]*0.95) And ([Forms]![Input form]![V]*1.05))) OR ((([Existing Metallurgy].[W]) Between ([forms]![Input form]![W]*0.95) And ([Forms]![Input form]![W]*1.05))) OR ((([Existing Metallurgy].[Zn]) Between ([forms]![Input form]![Zn]*0.95) And ([Forms]![Input form]![Zn]*1.05))) OR ((([Existing Metallurgy].[Pb]) Between ([forms]![Input form]![Pb]*0.95) And ([Forms]![Input form]![Pb]*1.05))) OR ((([Existing Metallurgy].[Al]) Between ([forms]![Input form]![Al]*0.95) And ([Forms]![Input form]![Al]*1.05))) OR ((([Existing Metallurgy].[Sn]) Between ([forms]![Input form]![Sn]*0.95) And ([Forms]![Input form]![Sn]*1.05)));
This query works fine as a first step as it narrows down the results but I'm stuck for what to do next. I used OR because I cannot get the AND to work if the boxes are null or ""