Weird return of Information (1 Viewer)

[krc547]

I have a table and I created a query that I wanted it to pull a certain type from the field for the fiscal year that was asked. In my criteria I had "Fixed", then I decided I needed to see "Special" as well so I added it to the or field in the query and then it returned not just fiscal 2023 which is what was asked for but all the way back to fiscal year 2017. I included before and after screen shots for this.

Before adding Special:

After adding Special

Any ideas on what I did wrong?

 

[isladogs]

Filter for criteria using Where instead of Group By

 

[krc547]

Worker perfect! Thank you

 

[The_Doc_Man]

Should be noted that, if it is desired to somehow segregate the return-set according to the TYPE field, you need TWO query columns naming the same field... one with GROUP BY (and no criteria) and one with WHERE (and the two options you wanted to see.)

As a side note... your field "TYPE" uses a reserved word as its name. This could lead to syntax ambiguity, which could lead to wonky results.

List of reserved words in Access - Microsoft 365 Apps

Lists the reserved words that you should not use in field, object, and variable names. It is not practical to provide a list of all reserved words, such as built-in function names or Access user-defined names.

learn.microsoft.com