Hiding Crosstab Queries

[Pvarga]

I am having a hard time hiding only my crosstab queries. Select queries are fine but the crosstab seem to be hidden until I look with create a query with wizard and them they are on the list.

Any ideas?

Thanks

 

[spacepro]

Hi,

Have you selected the Hidden field on Properties of the objects.

I have just tried this in my db and selected Hidden on properties of the query, and then created a simple query with the wizard and the hidden query doesn't appear on the list.

If this Happens try prefixing the query "Sys".

Hope this helps

Andy

 

[Pvarga]

Hiding Queries

Yes I have checked hidden. It seems only the crosstab queries are showing on the wizard list.

I may delete and rebuild them. Can't think of amything else.

Thanks

 

[spacepro]

Have you tried prefixing the query with "SYS". and secondly check the options settings:

Tools > Options

And Check on the View Tab etc, there might be a setting that is showing this up.

Just a thought.

Andy

 

[Pvarga]

Hiding Queries

Yes I did try sys and usys and checking that system files are not displayed.

This is quite frustrating.

Thanks for trying.