joint expression problem - query

[tekquest]

guys,

when I try to edit queries in my database, i get an error message:

microsoft access cannot represent the joint expression transaction.number = tempimport.field1 in design view.

* one or more fields may have been deleted or renamed
* the name of one or more fields or tables specified in the join expression maybe misspelled
* the join may use an operator that isn't supported in design view, such as > or <.

I cannot find a table called "tempimport"and when i click ok to that error message, i can see the data and in the update query it has the tempimport box, but with no subfields...

is this a problem? or should i ignore it ?

thanks,

Luke

 

[Mile-O]

Try importing your database into a fresh database and see if the problem persists.

 

[tekquest]

cheers!

mile-o-phile,

worked, brilliant!

thanks for that!!!