search form

hello
I am having issues with the size range search on my form. I would like to be
able to search within a range of diameters. the form is based off query that
looks like following.

SELECT AllAnalysis.AutoNumber, AllAnalysis.[Product Name], AllAnalysis.
Diametermeters, AllAnalysis.[Product Application], AllAnalysis.[TSR NO],
AllAnalysis.Diametermeters AS [Size], AllAnalysis.Supplier, AllAnalysis.[TSR
NO], AllAnalysis.[Polymer Abbreviation], AllAnalysis.Denier, AllAnalysis.
[MaxLoad(lbs)], AllAnalysis.[Tenacity(g/den)], AllAnalysis.[StrainAtBreak(%)],
AllAnalysis.[Young'sModulus(gf/den)], AllAnalysis.[StrainAt5g/tex(%)],
[product name]=Forms![Alternative Search Form]![txtproduct name] Or Forms!
[Alternative Search Form]![txtproduct name] Is Null AS Expr1, [Product
Application]=Forms![Alternative Search Form]![cboproduct application] Or
Forms![Alternative Search Form]![cboproduct application] Is Null AS Expr2
FROM AllAnalysis
WHERE ((([product name]=[Forms]![Alternative Search Form]![txtproduct name]
Or [Forms]![Alternative Search Form]![txtproduct name] Is Null)=True) AND ((
[Product Application]=[Forms]![Alternative Search Form]![cboproduct
application] Or [Forms]![Alternative Search Form]![cboproduct application] Is
Null)=True) AND (([diametermeters]=[forms]![alternative search form]!
[txtdiametermeters] Or [forms]![alternative search form]![txtdiametermeters]
Is Null)=True) AND (([supplier]=[Forms]![Alternative Search Form]!
[cbosupplier] Or [Forms]![Alternative Search Form]![cbosupplier] Is Null)
=True) AND (([polymer abbreviation]=[Forms]![Alternative Search Form]!
[cbopolymer abbreviation] Or [Forms]![Alternative Search Form]![cbopolymer
abbreviation] Is Null)=True) AND (([tsr no]=[Forms]![Alternative Search Form]!
[txttsr no] Or [Forms]![Alternative Search Form]![txttsr no] Is Null)=True));


the form is only returning data based on the min diameter entered and not
between the mim and max

anyhelp is appreciated.

--
Message posted via http://www.accessmonster.com

Try www.fontstuff.com Some very good search functions explained.

"misschanda via AccessMonster.com" wrote:

hello
I am having issues with the size range search on my form. I would like to be
able to search within a range of diameters. the form is based off query that
looks like following.

SELECT AllAnalysis.AutoNumber, AllAnalysis.[Product Name], AllAnalysis.
Diametermeters, AllAnalysis.[Product Application], AllAnalysis.[TSR NO],
AllAnalysis.Diametermeters AS [Size], AllAnalysis.Supplier, AllAnalysis.[TSR
NO], AllAnalysis.[Polymer Abbreviation], AllAnalysis.Denier, AllAnalysis.
[MaxLoad(lbs)], AllAnalysis.[Tenacity(g/den)], AllAnalysis.[StrainAtBreak(%)],
AllAnalysis.[Young'sModulus(gf/den)], AllAnalysis.[StrainAt5g/tex(%)],
[product name]=Forms![Alternative Search Form]![txtproduct name] Or Forms!
[Alternative Search Form]![txtproduct name] Is Null AS Expr1, [Product
Application]=Forms![Alternative Search Form]![cboproduct application] Or
Forms![Alternative Search Form]![cboproduct application] Is Null AS Expr2
FROM AllAnalysis
WHERE ((([product name]=[Forms]![Alternative Search Form]![txtproduct name]
Or [Forms]![Alternative Search Form]![txtproduct name] Is Null)=True) AND ((
[Product Application]=[Forms]![Alternative Search Form]![cboproduct
application] Or [Forms]![Alternative Search Form]![cboproduct application] Is
Null)=True) AND (([diametermeters]=[forms]![alternative search form]!
[txtdiametermeters] Or [forms]![alternative search form]![txtdiametermeters]
Is Null)=True) AND (([supplier]=[Forms]![Alternative Search Form]!
[cbosupplier] Or [Forms]![Alternative Search Form]![cbosupplier] Is Null)
=True) AND (([polymer abbreviation]=[Forms]![Alternative Search Form]!
[cbopolymer abbreviation] Or [Forms]![Alternative Search Form]![cbopolymer
abbreviation] Is Null)=True) AND (([tsr no]=[Forms]![Alternative Search Form]!
[txttsr no] Or [Forms]![Alternative Search Form]![txttsr no] Is Null)=True));


the form is only returning data based on the min diameter entered and not
between the mim and max

anyhelp is appreciated.

--
Message posted via http://www.accessmonster.com