Due time? > Please help!

[cklein]

Hello,

I'm very new to Access so I try to explain my problem:

I have a form where I get the date automaticly
but I would also like to have a due by date.

For example, if today is 02.09.2003 then the
customer should pay the bill at least one week from today.
The last payment date should be see on the bill.

If anyone has got the time to help me out I'd be very grateful.
Step by step instruction would be the best solution for me, because if you would send
me a code I'd have no idea what to do wit it.

With best regards,

Calvin

 

[Jack Cowley]

I do not know how you get our date automatically so it is hard to tell you where to put the code so that it will add 7 days to your date and place it in the control for Date Due. If you are getting your date by using =Date() in the Default Value of the Date Field then use = Date() + 7 in the Default Value of the Due Date control.

hth,
Jack

 

[WayneRyan]

calvin,

You can base a query on your table. Put all of the fields that
you want. For this example, you have two fields; DateBought
(which you assigned =Date() on your form) and a checkbox IsPaid
(which you fill out later on your form).

In your query, in the Criteria section, for IsPaid put: =False
and under the DateBought put: < Date() - 7

That should do it, experiment with it!

Wayne

 

[cklein]

Thank you.

Now that I looked into it, it was really easy.

Thanks again.