Query to make rows of data in columns

A

Aaron

Is it possible to create a query to pull transactional data by month stored
in rows and create a result that shows the transactional data in columns?
Currently, the the numbers are stored in the same column but can be
differentiated by another column that contains the date of the number. In
the end, all of January's data would be in one column. February would be in
another. All of the way until to the end of the year. Thank you!
 
A

Aaron

Hi Dorian - thank you very much for your help. I was trying to do too much
in one query. I had to first do a crosstab query and then create a custom
query to match that result with another table. I was able to obtain my
results. Thank you so much!
 
Top