[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