Query files not appearing

[Lanason]

Heres an odd thing:-
I have a query based on a query
when i added a new field to the base query, this field did not appear in the list of fields in the design definition when i try and add to the upper query. (Hope that made sense) it just shows the original fields only.

Same thing happened in a field on a report -i had to delete the field and create it again

any ides?

 

[pr2-eugin]

Compact & Repair followed by a Compile generally solves this problem.

 

[vbaInet]

By the way, did you save and close the query after adding the field?
Did you re-add this query to the other query via Show Table?

 

[Lanason]

How do i do a compile??

Yeah I tried adding the base query again to the upper query using show tables and it showed the original fields only.

I saved the original query and reopened it and the new fields appeared Ok
:banghead::banghead::banghead:

 

[vbaInet]

Ok, but did you re-add the base query after saving and closing it?

pr2-eugin is talking about Compact & Repair, not Compile.