List Dates From Query By Real Calendar Date Not Alphabetized, Access 2010

[jfiresto]

I am using a query to show dates and weights for a certain date range. I would like the information displayed in real calendar dates not alphabetized. The dates are stored in a date field (Date Property Processed) and the weight are stored in a numerical field (Total Property Weight Received). Also if the month contains no data, I would still like to show the month with "0" in the weight field. Attached is a copy of the query I am using right now. I really could use some help, thanks in advance.

John



SELECT DISTINCTROW Format$([Property Weight].[Date Property Processed],'mmmm yyyy') AS [Date Property Processed By Month], Sum([Property Weight].[Total Property Weight Received]) AS [Sum Of Total Property Weight Received]
FROM [Property Weight]
GROUP BY Format$([Property Weight].[Date Property Processed],'mmmm yyyy'), Year([Property Weight].[Date Property Processed])*12+DatePart('m',[Property Weight].[Date Property Processed])-1;

[June7]

Include ORDER BY clause in the query:

ORDER BY Format$([Property Weight].[Date Property Processed],'yyyymm')

Sorry, can't show data that doesn't exist. If there is no weight data for particular month, meaning there is no record, then there is nothing for the query to retrieve.

One way to show all yyyymm regardless if there is no weight data requires a 'master' data source of all possible yyyymm values, then join that source to the posted query, jointype 'Include all records from yyyymm table ..."