[AccessD] Help with string

Are you trying to build a SQL Statement? 




John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Spell, Cynthia G.
Sent: Tuesday, March 20, 2007 7:21 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Help with string

 
Hi,
Can someone help with the following string?  FA is text, Funding is text,
and Month is numeric.

stCriteria = "[FA]= '" & Me![cboFA] & "' And [Funding]= '" & Me![cboFunding]
& "' And [Month] = Me![cboMonth]

Thanks very much.
Cindy Spell
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com