Prev: I need to add the letter "Z" to the end of every contract ID
Next: Extract Data from a Field
From: Bob on 14 Jan 2010 10:04
I have a query that pulls an employees license information from the training
table and links the emp id field to get their name from the employee database.

I have the query that asks for the state abbreviation to be input and then
pulls up the record providing the term date is null and training field
specifies License. It then pulls up the name, state license number and
license expiration date.

The input field is just the basic input you create within brackets in the
query design mode.

It works fine for every state I have tried except MI and I get a No Current
Record error. MN is fine, CA is fine, MS is fine, etc.

Any ideas?
From: Dorian on 14 Jan 2010 10:14
Are you sure you have a record for MI?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Bob" wrote:

> I have a query that pulls an employees license information from the training
> table and links the emp id field to get their name from the employee database.
>
> I have the query that asks for the state abbreviation to be input and then
> pulls up the record providing the term date is null and training field
> specifies License. It then pulls up the name, state license number and
> license expiration date.
>
> The input field is just the basic input you create within brackets in the
> query design mode.
>
> It works fine for every state I have tried except MI and I get a No Current
> Record error. MN is fine, CA is fine, MS is fine, etc.
>
> Any ideas?
 | 
Pages: 1
Prev: I need to add the letter "Z" to the end of every contract ID
Next: Extract Data from a Field