How to get access to generate a deadline date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Access 2003. The database I'm trying to create tracks quality
complaints from my customers. I've created a form that generates an ID with
auto number, allows the user to input the complaint, who the customer was
that complained, the date the complain was made. I want to get access to
generate a deadline date automatically. The date will be atleast 30 days
from the date the complaint was received. I have 2 tables: 1)list of
customers and 2)problem table. The problem table includes a field for the
deadline date. I've tried using an expression to generate the deadline date,
but with no success. I'm new to access and I'm trying to learn this program
as quickly as possible. Any help would be appreciated.
 
chris,
several ways to do that. easiest way maybe to set the default value of
the deadline day in the table.
set the default value to =date()+30
 
Jeff,
Thanks for the help. I tried it but it didn't work. Do you have any other
suggestions?
 
Back
Top