I have a database that has four different date fields. Each date field is associated with a Process. What I am doing in my table is ... I have a status field that has 5 statuses to select from. Once the status is selected the user enters the date.
So:
review 2/3/22
Approved 2/19/22
Published 2/5/22
and so on. Is there a good way to run a query that would give me a result that would show by status the dates?
I want to make a report that puts all the Reviews together, all the Approved together ect.
So report...
Header:
______________
Review1 (Date)
Review2 (Date)
Review3 (date)
_______________
Appreced1 (date)
Approved2 (date)
______________
Published1 (date)
Published2 (Date)

I am a bit new, I have a good grasp on the basics but the code is all new to me. I have been watching a lot of videos that get me part way there but I don't seem to be getting all the way there. Any help is greatly appreciated.