Design View - deselect all fields

[nagileon]

Hi there
Is there any way of de-selecting all the fields in Access 2007 Design View of a query ?


Regards
Peter

[HiTechCoach]

Are you wanting to remove all the fields form the query's grid?

[nagileon]

Yes. I will then select one or two columns. But deselecting all of them manually is a pain.

[HiTechCoach]

If you are deleting all the fields I normally just start a new query and add the tables. You also could delete the tables(s) and add then back.

I assume you are in the query design view and you are click at the top of a column to select it.

You can also select one column. Then hold hold the shift key and use the left or right arrow key to select a range. Then press the delete key.

You can also click to select the first column and while holding do the mouse drag over all the columns you want to select.

[nagileon]

The problem is that I will never know which fields are empty because of quite a dynamic nature of this data. So first I need to run the select * from x query and then take a look and exclude those fields that are empty. In this scenario I have to go through 45 checkboxes and deselect them manually.Which is a pain.

[HiTechCoach]

In 15+ years developing many applications with Access I have not had to do anything like this.

I am regularly filtering out records not fields in the same record.

How many table are in the query to get so many field in a single record?

Does your query return multiple records?