Prev: How do I maintain macros on a Custom Toolbar
Next: Logical Expression as just a word?
From: Alan on 9 Apr 2010 09:29


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??
From: John Spencer on 9 Apr 2010 10:07
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

Alan wrote:
>
> 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??
 | 
Pages: 1
Prev: How do I maintain macros on a Custom Toolbar
Next: Logical Expression as just a word?