Mar 18, 2003 #1 Shazza Technical User Aug 21, 2000 38 NZ I would like to have a subreport display for every month of the year. I don't have a field in my database that will display a group for every month. Can I set up a formula that will allow me to use this to group.
I would like to have a subreport display for every month of the year. I don't have a field in my database that will display a group for every month. Can I set up a formula that will allow me to use this to group.
Mar 18, 2003 #2 Ngolem Programmer Aug 23, 2001 2,724 CA well you must have something in your database with a date in it to be able to judge if a record is in one month or another. Perhaps it is a date is the form "mmddyyyy" for example If you have such a field then you just have to extract the month out of the date and create a formula to group on that. Jim Broadbent Upvote 0 Downvote
well you must have something in your database with a date in it to be able to judge if a record is in one month or another. Perhaps it is a date is the form "mmddyyyy" for example If you have such a field then you just have to extract the month out of the date and create a formula to group on that. Jim Broadbent