Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group on non database field

Status
Not open for further replies.

Shazza

Technical User
Aug 21, 2000
38
0
0
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top