How do I code it to say this month and next month....

  • Thread starter Thread starter Tony Vrolyk
  • Start date Start date
T

Tony Vrolyk

you could...

In the underlying query create a field something like this
Range: Format([DateField],"mmm") & '-' &
Format(DateAdd("m",1,[DateField]),"mmm")

in sql it would be
Format([DateField],"mmm") & '-' & Format(DateAdd("m",1,[DateField]),"mmm")
AS Range

Tony
 
I have a report that has days from todays date out to Dec 20.
For the report Title I want it to say NOV-DEC. How do I do this?
I know it has something to do with datepart? datediff?

Thanks in advance...
-Rick
 
Back
Top