[AccessD] Help with a Select Query

Hi Cynthia,

As Doris said, perhaps a Like criteria would to the trick for both A
and B if they want them. (Like "64*") But with only A and B as options
you might not be too bad off just having them enter "64A" or "64B" in
there too.  You can list multiple criteria values in there seperated
with ORs.

GK

On 7/18/08, a2965z-nonprofit at yahoo.com <a2965z-nonprofit at yahoo.com> wrote:
> 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
>


-- 
Gary Kjos
garykjos at gmail.com