Query Error

[amfroehlich]

I am in the process of finsihing up my forms and reports. But, everytime i make a querey from more then one table I am getting this error. "The wizard is unable to open your query in datasheet view, possibly because another user has a source table open in exclusive mode." Then if i try to open after it is made, i get a "Type mismatch in expression error".

Can anyone tell me what is going on? Or what I am doing wrong?

Thanks,

Aaron

 

[Ziggy]

Do you have any forms/reports or queries open that are related to the one your trying to work with, are you trying to edit a shared DB on the network when some one else already has it open?

Describe how you are setting up your queries with more than one table.

data mismatch will occur if you trying to calculate different datatypes like one field with text type and the other with Integer type. You can convert text to Integer with Cint function. post your expression