Form to display current month's targets?

[CW]

We have a welcome form on our system that displays the current month's target
enquiries and bookings figures.
At present those figures are entered manually at the start of each month,
but I would like to store all the year's figures in a table month by month
and then have the system automatically pull the appropriate numbers when the
month changes.
I'm fine with the table design, but how do I tell the form to check the
current date and then display the relevant figures? (Or would it be best to
use a query to do this?) Many thanks
CW

 

[Al Campagna]

CW,
Several ways to do that...
Try adding a month number to each target record.
TargetDesc TargetMonth
XXXXX 1 ' Jan
YYYYY 11 ' Nov

In the query behind your form, use a criteria against TargetMonth...
=Month(Date())
Every time the date month changes... your displayed targets will follow
suit.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[CW]

Perfect! And so easy!
Many thanks, Al
CW

CW,
Several ways to do that...
Try adding a month number to each target record.
TargetDesc TargetMonth
XXXXX 1 ' Jan
YYYYY 11 ' Nov

In the query behind your form, use a criteria against TargetMonth...
=Month(Date())
Every time the date month changes... your displayed targets will follow
suit.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."





.