The table has a birthday (input mask is "Short Date", i.e," 9/12/1956", and I want to build a report that groups records by the month of the [birthday] field. The sorting is currently set at [birthday], [ last_name], [first_name] which puts all the records in birthday order by year, month, day, lastname, firstname. How do I make the report group the records by month, i.e., show all records with birthdays in January (regadless of birth year), then February, etc.

Create a "field expression" to return the month value of the birthday field ...
Example:

This will return the numeric month value ..
You can then group by this field expression ...

RDH

Look at using the DatePart statement as (another) output field from your query, and then base the grouping on THAT

Thanks! Worked like a charm once I figured out where to stuff the expression.

That is great ... You are welcome .. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

RDH