Multiple dates in a database

  • Thread starter Thread starter pat
  • Start date Start date
P

pat

I need to have an initial contact date and a latest
contact date in my database. I have not been able find
anything to help. Any suggestions?
 
Pat,

In your table, you need two fields. One for initial
contact date, one for latest contact date. When you setup
the overlaying form, you don't have to show the initial
contact date if you don't want to, just set the default
for the field in the table to =now(). For the most recent
contact date, you will probably need a control on your
form you can use to enter the date. There are probably
programmatic ways using VBA, but the way suggested here
would be the easiest. If you want something more, e-mail
me at the referenced address.

Kevin
 
The only other thing you could do is have another table
with Contact ID as a foreign key to you main contacts
table. In the table would be four fields:

Field name Field Type
ID Autonumber
contactID long
Date date/time
Contact type text

In contact type you would record Initial, subsequent,
etc.

You would need a form and subform setup. With some more
knowledge about what your trying to do and with some
thought, I could probably give you more direction, but at
the current time (it's 12:16 am here) I an incapable of
that! :=)

Hope this helps!

If you want more help, sned me an e-mail at the
referenced address and I will give it some more thought
as time permits.

Kevin
 
Back
Top