Missing Fields

[TKnight]

Hi, In a query that i've designed, i have a number of hidden fields. Usually when i've done this before the hidden fields go to the rightmost columns when i save and close the query. With this particular one, some of the hidden fields are on the right and some are totally missing in design view. If I run the query they appear alongside the other data (on the right incidentally) but I can't view them in design view. Is there any way I can get them back or do I need to rebuild the query, thanks, Tom.

 

[dcx693]

That's really weird. Are they listed in the SQL view? If so, take the SQL code and recreate the query.

 

[TKnight]

Ahh i didn't think of that. It must be in the sql view because the fields were there when the query ran. I re-built it again anyway only took a few mins. Thanks for your help mate, Tom.

 

[Mile-O]

If you check the fields to be hidden in the query and don't specify any criteria, etc. for them then Access removes them.