[AccessD] Help with a Select Query

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





More information about the AccessD mailing list