State abbreviation MI fails in query

B

Bob

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?
 
D

Dorian

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top