[AccessD] (no subject)

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