Is there an easier way to select every column but one in a table with a query in Access 2016? [closed]
Is there an easier way to select every column but one in a table with a query in Access 2016? [closed]
I have a table with many column such like Name, Country, Gender, ID etc. Is there an easier way to do select every column of this table within a query except the Gender column?
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
I use both. Easier as opposed to select every single column one by one (I have a loooot of them).
– Ice s. Woo
Sep 12 '18 at 18:22
1 Answer
1
You can use Shift+Click to select all fields in the GUI, then either Ctrl+Click to deselect the ones you don't want before dragging them down or delete the columns once you drag them down.
For aliases just add the alias with a colon before the column name like this:
Sex: Gender
Easier as opposed to what? Are you using SQL or the GUI?
– SunKnight0
Sep 12 '18 at 18:19