spiderghd New member Local time Yesterday, 19:44 Joined Jan 18, 2008 Messages 9 Jan 30, 2008 #1 I have a report that I am grouping by month. How do I get the Group Header to print the month if the name of the month is not in the data?
I have a report that I am grouping by month. How do I get the Group Header to print the month if the name of the month is not in the data?
boblarson Smeghead Local time Yesterday, 16:44 Joined Jan 12, 2001 Messages 32,059 Jan 30, 2008 #2 How is it currently in there?
spiderghd New member Local time Yesterday, 19:44 Joined Jan 18, 2008 Messages 9 Jan 30, 2008 #3 example 1/12/07, 3/30/07.... I want the group header to be able to list January, February and so on for each section.
example 1/12/07, 3/30/07.... I want the group header to be able to list January, February and so on for each section.
boblarson Smeghead Local time Yesterday, 16:44 Joined Jan 12, 2001 Messages 32,059 Jan 30, 2008 #4 Just take and change the control source for the current displayed date and use: Code: =Format([YourGroupedFieldNameHere],"mmmm")
Just take and change the control source for the current displayed date and use: Code: =Format([YourGroupedFieldNameHere],"mmmm")
spiderghd New member Local time Yesterday, 19:44 Joined Jan 18, 2008 Messages 9 Jan 30, 2008 #5 Sorry...The group header doesn't have any data at the moment. Only the groups have the date (dates).
boblarson Smeghead Local time Yesterday, 16:44 Joined Jan 12, 2001 Messages 32,059 Jan 30, 2008 #6 Copy the control with the date in and put it in the group header and then do the control source like I said.
Copy the control with the date in and put it in the group header and then do the control source like I said.
spiderghd New member Local time Yesterday, 19:44 Joined Jan 18, 2008 Messages 9 Jan 30, 2008 #7 Thank you Bob. It works great.
boblarson Smeghead Local time Yesterday, 16:44 Joined Jan 12, 2001 Messages 32,059 Jan 30, 2008 #8 Glad to hear