Hi,
I have a question for my query in which I have two fields Date and status (in the status only 3 values YES / NO / Other). I would like to use a query to count me the number of appearances after the statute in one line.
I have a question if it is possible to have all statuses in one line because now I used Group by. I have added my example in the attachment.