Originally Posted by
June7
Where are you doing this WHERE? In query object? I never use dynamic parameterized query objects. I use VBA to set filter criteria of forms and reports.
I get 221 characters as the length of the criteria.
Advise no spaces or punctuation/special characters (underscore only exception) in any names. Better would be FatG or Fat_g.
You have space in [Fat (g)] and [Protein (g)] but not in [Carbo(g)]. Be consistent.
Example:
[Prot_g] BETWEEN [Forms]![FSF]![PMin] AND [Forms]![FSF]![PMax] And [Carb_g] BETWEEN [Forms]![FSF]![CMin] AND [Forms]![FSF]![CMax] And [Fat_g] BETWEEN [Forms]![FSF]![FMin] AND [Forms]![FSF]![FMax]
That is 195 characters.