Crosstab Type Form??

[mounty76]

Hi Arnelgp,

Good idea but the date field in qry2 is a Group of dates from a total query that returns a grouped value of dates in a month...IE

1/1/21 45000
2/1/21 10000
2/2/21 5000
3/3/21 1000

Returns
Jan 21 55000
Feb 21 5000
Mar 21 1000

Therefore the left join query does not work as it's not a true date in qry2.....any ideas? I was thinking if I can do an expression to make a date formatted date that uses the month and year from the returned results? Not had much success yet though1

 

[arnelgp]

post sample db and i will show you.
from Qry2 create another query that you can Group by Format(dateField, "mmm yy").
join this new query to Qry1.