Naming Caption as current Month in query or report

G

GEORGIA

Is there a way to name the caption of your query or report as Current Month?
I've tried using format(date(),"MMM-YY") but of course, that shows up as a
title.
Right now this is what i have as a syntax in the query:
Current Month 60+: CCur(nz([qrypreviousmonthroll]![60+]))
I do a compairson between previous month and current month. Since it
changes every month, I can't name it Nov-05 or whatever the current and
previous month is. Any help would appreciated.
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top