Type Mismatch in Expression Error

G

Guest

I am trying to run a make table query from existing related tables that are
linked through a connection that updates their information daily. I have
dragged all the fields i need into their respective slots. When I tried to
switch to design view I was prohibited from doing so by this error message.
I have saved the query and upon trying to reopen it I was unable to due to
this same error message. Microsoft Access help has not provided any
answers.....PLEASE HELP!
 
J

John Vinson

I am trying to run a make table query from existing related tables that are
linked through a connection that updates their information daily. I have
dragged all the fields i need into their respective slots. When I tried to
switch to design view I was prohibited from doing so by this error message.
I have saved the query and upon trying to reopen it I was unable to due to
this same error message. Microsoft Access help has not provided any
answers.....PLEASE HELP!
Click to expand...

There is a problem in your query with mismatched field types.

Since we cannot see the query and know nothing about your table
structures, it's more than a bit difficult to determine what the
problem might be.

Give us a little help, please?

John W. Vinson[MVP]
 

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

Similar Threads

Type Mismatch in Expression 1
Error: Data type mismatch in criteria expression 0
Number to Number "Data Type Mismatch in Expression" in Join 1
Data mismatch error 2
Delete Query: Could not delete from specified tables 0
Type Mismatch Error depends on relation scheme appearance 3
type mismatch 1
"Data type mismatch in expression" 2

Top