First and Last in a summary report

[Steve_Bache]

Anyone help please?
I have a monthly summary report(from a query) for the year to date with one page per month and an overall summary page. How can I print the first and last months on the overall summary page showing months reported to date - e.g. Yearly Report 2006 January to May ?
Please keep it as simple as possible as I'm still fairly new to Access !

Steve

 

[Rich]

=Min("MM",[YourDate]) & "to" & Max("MM",[YourDate])

 

[Steve_Bache]

Hi Rich,

Thanks for the info. Having tried this I can get the code to work but ONLY without the "MM" part of the expression - why is this ? MyDate is in short date format.

Other questions (if you have time ) :-
1) assuming I can get this to work, how can I display the literal for the month instead of the numeric value i.e. January instead of 1 ?

2) I have another date in the query that would be easier to use as it already just contains just the literal for the month ( RequestMonth: Format$([FOI_Requests].[RequestDate],'mmmm' - from the query) that I have tried using.

However, if I use this field with the Max Min expression, I get April and May returned as opposed to 01/01/2006 to 30/05/2006 displayed by the Min Max expression on MyDate (dates of first and last records returned from query) - any idea why I'm not getting January to May ?

Hope that makes sense !

Thanks in advance

Steve

 

[Steve_Bache]

Hi Rich ,

Just realised why the RequestMonth expression is returning April to May ! Obviously correct 'cos the field is alpha !

Forgot to mention the reason that your suggestion wasn't working - message returned .....function containing the wrong number of arguments.

Cheers

Steve