Let’s imagine I have a query with a column called Reportid – and I want to create another query with the unique values from the column.
Normally I would create a new blank query and than reference the column with – queryName[ColumnName]
And then there are a bunch of other steps which eventually lead you to the result. Or you can go straight to easy mode. That sounds like a pretty good idea to do instead.