State abbreviation MI fails in query

  • Thread starter Thread starter Bob
  • Start date Start date
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?
 
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".
 
Back
Top