Doris Manning
mikedorism at verizon.net
Fri Jul 18 14:09:17 CDT 2008
Why not do a LIKE search and put in a wild card character after the district (example: ##* for Access... ##% for SQL Server). Doris Manning Database Administrator Hargrove Inc. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of a2965z-nonprofit at yahoo.com Sent: Friday, July 18, 2008 2:55 PM To: accessd at databaseadvisors.com Subject: [AccessD] Help with a Select Query Hello, I have a client for whom I have created a simple query that returns either a home or work record if they reside within a specific district. In other words they select home or work then enter the desired district. All is well so far. The district consists of two digits 01 - 64 followed by either an 'A' or 'B'. Right now the client can request either A or B (because it's part of the district) but they would also like to be able to request both A and B. I'm really new at this and I'm wondering if there's a simple way to modify the query so they can designate either A or B or Both. The district field is three characters ##A or ##B. Each has its own district ID. Thanks, Cynthia -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com