Access Tables

[hwkyetkd11]

I currently have 7 tables and want to consolidate some of the information from them into one. I have been trying to construct a table through a Query but it says I have entered an expression that has an invalid reference tot he property and then will not set up the look up wizard. Cana ny one help please

 

[lynchg]

Switch to the SQL view of your query and copy and paste it into another posting. I don't think anyone could tell you exactly what is wrong without looking at your SQL.