Spell, Cynthia G.
cspell at jhuccp.org
Tue Mar 20 06:46:59 CDT 2007
I am building a SQL Statement, but I just figured it out. Thanks, John. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Tuesday, March 20, 2007 7:33 AM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com