|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 20th, 2005, 04:45 PM
|
|||
|
|||
Simple Expression Question
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. 
|
|
#2
September 20th, 2005, 04:56 PM
|
|||
|
|||
|
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" wrote in message ... 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.
|
|
#3
September 20th, 2005, 05:17 PM
|
|||
|
|||
|
perfect thanks
"Rick B" wrote: 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" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Question With A Expression | Lee | Running & Setting Up Queries | 1 | April 29th, 2005 09:19 PM |
| Simple question | Sheila Clarke | General Discussion | 2 | March 24th, 2005 04:31 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Simple stupid question | Jose Esteves | New Users | 7 | September 3rd, 2004 04:58 PM |
| Simple Excel Question | Scott B. Hogle | Worksheet Functions | 3 | March 14th, 2004 11:53 PM |
Linear Mode
