Simple Expression Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I keep track of training sessions in a table. I want to run a query that
will prompt me to enter in a Last Name, then First to list all training
sessions that person has attended. Lost....too new to Access to understand,
but learning. Ever so slowly.
 
In your query, under the Last Name field (in the criteria) put...

Like "*" & [Enter partial last name to locate] & "*"

under the first name, put...

Like "*" & [Enter partial first name to locate] & "*"
 
perfect thanks

Rick B said:
In your query, under the Last Name field (in the criteria) put...

Like "*" & [Enter partial last name to locate] & "*"

under the first name, put...

Like "*" & [Enter partial first name to locate] & "*"

--
Rick B



QRATRAINER said:
I keep track of training sessions in a table. I want to run a query that
will prompt me to enter in a Last Name, then First to list all training
sessions that person has attended. Lost....too new to Access to understand,
but learning. Ever so slowly.
Click to expand...
Click to expand...
 
Back
Top