automating data entry

[phineas629]

I have recurring charges for each client everyday for the whole year.

i.e. client A has 2 units charged per day for 365 days.

client B has 3 units charged per day for 365 days.

client C has 1 unit charge per day for 365 days.




How would I automate my data entry? There may be a change in charge maybe only 2 days out of the year for which I would have to manually change.

Any ideas?

Thanks.

[NTC]

more than one way to skin the cat;

have a table for recurring charges with the key customer, amount, item info....then have a form area for Set Recurring Charges - select day (auto defaulting to today) - and a button that triggers an Append Query. ...that way on mondays you can go back and set the weekend days...

unless you want to do all 365 at once in bulk; a bit of vb to dateadd +1 365 times or 1 append query using a static date table with 365 records....

hope it helps.

[phineas629]

Thanks NTC,

I will give it a shot. I want to stay up to date so I like option 1. I'm pretty new to programming in general so I'm pretty lost with what you wrote. It's not for lack of trying. Hopefully, I will be giving out advice by year'end rather than just always receiving.