[AccessD] (no subject)

Karen

...sent you an old sample mdb off-list that shows you how to do this.

William

----- Original Message ----- 
From: <krosenstiel at comcast.net>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, February 25, 2008 1:24 PM
Subject: Re: [AccessD] (no subject)


> Charlotte,
> I specified that the criteria was on the Lname field in the query.
>
> Susan, Arthur and Mark suggested a popup form so I will play with that.
>
> Thanks all.
>
> --
> Karen Rosenstiel
> Seattle WA USA
>
> -------------- Original message ----------------------
> From: "Charlotte Foust" <cfoust at infostatsystems.com>
>> You can't use like to get an exact match, except by accident.  Are you
>> doing this from a form?  If so, a combobox populated with the "Like"
>> results would allow the user to select the particular individual for the
>> report.  Unfortunately, if your data is keyed only on LName and FName,
>> you won't be able to handle people with the same name.  And comboboxes
>> give you the first match, so the underlying value needs to be a
>> concatenation of the first and lastname fields.  If you are just looking
>> at the results of a query, then you need to add a criteria "Like"
>> expression under the FName field too, on the same line in the grid so
>> that you create and And condition.
>>
>> We need more information about exactly what you're doing to advise you
>> appropriately.
>>
>> Charlotte Foust
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> krosenstiel at comcast.net
>> Sent: Monday, February 25, 2008 9:35 AM
>> To: DBA-AccessD
>> Subject: [AccessD] (no subject)
>>
>> >From a patient database in Access 2003, I want to pick the right
>> patient for a report of individual details. I have fields Lname, Fname
>> and Mname. In the query on the Lname field I have the following as the
>> criteria:
>>
>> Like "*" & [Enter Last Name] & "*"
>>
>> This works fine to pick all the Johnsons, including "Johnson, Jr."
>> However, the report is then returning all the Johnsons in sequence, but
>> I only want 1 particular Johnson with his/her individual details. How do
>> I get the query to give me a list of "Johnsons," including first and
>> middle names, from which I can pick the right patient to plop into the
>> report?
>>
>> MTIA -- and please keep it simple, I'm not very advanced with Access
>>
>>
>> --
>> Karen Rosenstiel
>> Seattle WA USA
>> --
>> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>