Help with pivot

[Alan]

I have this

strSQL = strSQL & " Pivot [Sales Analysis].[Quarter] In (1,2,3,4)"

with text box named 1,2,3,4


and then i have this

strSQL1 = strSQL1 & " Pivot [1a11f raw].[Quarterly] in (1f,2f,3f,4f)"

with text box name 1f,2f,3f,4f,

why doesn't that second part work??

 

[John Spencer]

1,2,3,4 are number values and don't require text delimiters.
1f,2f etc are text values and require text delimiters.

" Pivot [1a11f raw].[Quarterly] in ('1f','2f','3f','4f')"

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County