I have data in two simple tables:

1) A simple EMR with gender, positivity, and date 2) A simple accounts management table, with total numbers of people going through each medical procedure also categorized by date

I wanted to make a form that would define the parameters for a query that would supply a report that combines data from both tables and separates them by month. So essentially:

Form -> Parameters for Query (Date Range)) -> Query Pulls Data by the parameters provided (Date Range) -> Data is Supplied for Report (Grouped by Month/Year)

However, I struggle with exporting the data from query to be separated by Month or even arranged by date. It consistently totals all the numeric information for the range provided. I think a cross tab would be useful here but idk how to do that. Or is it possible to separate the data when in the Report Design mode?