I used the formula MonthName(month({demogrph.dm_dob})) and then grouped the results "in specified order" so they were in monthly order rather than alphabetical order. Thanks to all for the help.
I work in a school and I'm trying to create a monthly student birthday report. I want the report be grouped by month. The database I am using records date of birth in one field (MM/DD/YY). The formula I am using is "If {demogrph.dm_dob}[1 to 2] = "01" then "January"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.