Hi all, I'm having one of those days when the brain is dead.
I have a table that has "Date" "Item Id" & "Quantity Purchased".
What I would to do is make a query that can group the puchases into their relevant months, ie Jan, Feb, Mar etc. The date is in "Short date" format. From this query I would like to make a form where people can select a month to print out in a report.