How to automatically add a number to a table on a certain date?

R

RMCDD997

I track my vacation & sick days. The first of each month I earn 1 sick day
and manually enter it. How can I set it up to automatically add 1 to my table
on the first of each/every month? Thanks.
 
R

RMCDD997

my "tblEarned" has 4 fields, EarnedID, DateEarned, TypeEarned (vacation,
sick) & MinutesEarned (all earned time is entered in minutes). On the 1st of
each month, I enter 480 MinutesEarned on my form. I would like to
automatically generate an entry on the 1st of each month - as DateEarned,
Sick - as TypeEarned and 480 as MinutesEarned.
 

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

Similar Threads

I'm sure its an easy answer.... 1
How to map SharePoint drives permanently 0
How can the font and size of (all) citation numbers be altered? 1
if statement = if number is between 1
Really, Really Need Help Tracking Employee Attendance 8
Using other equations inside of SUM? 1
in excel, what is the formula that will add a number each month 0
Calculate leave time in a query 4

Top