Sorting columns in Queries

[marthacasting]

Why is it that when trying to sort data in queries, some of the columns have a special icon next to the field name that opens a dropdown list of all the different answers in the column, and you can put checkmarks next to those you want.

And other columns allow you to sort either A to Z or Z to A, and still other columns only allow you to do a dropdown with the ability to filter and give you this message: Syntax error (missing operator) in query expression 'Support Group'.

 

[CJ_London]

And other columns allow you to sort either A to Z or Z to A, and still other columns only allow you to do a dropdown with the ability to filter and give you this message: Syntax error (missing operator) in query expression 'Support Group'.

it's to do with the type of query - this message happens if you are looking at an append query in datasheet view for example

 

[marthacasting]

Thank you. I'm not sure what you mean by an append query . . .

 

[CJ_London]

look at the ribbon in query design view, you will see all the options. You might no an append query as an insert query

 

[jdraw]

marthacasting,

The is an online introduction to SQL at w3schools here.

Also, there are several good , free youtube videos concerning SQL.
Here is one by Richard Rost.

Good luck.