Normalize - dates, how to connect?

C

carrietom

Hi,

I am revamping a database to normalize the dates so that I can report on the
most recent due date for each record. It is my understanding that I need one
date field.

I have set up a table with Date_Category (Action, Due or Reminder) and
Date_Type (there are 23 types). Each Due Date has a calculated Reminder
Date (when to send the reminder out). Some of them have an Action Date
(which is a date that we would have made a request, or notified.

What I need is to be able to report where the most recent due date will
print with information regarding the action and the date that the reminder
should be sent out. (there are other non-date fields in the Main Table). I'm
struggling with how to get the correct action and reminder tied into the
right due date. I'm wondering if I need more tables?

Thanks very much!
 
K

KARL DEWEY

Do different types have different due date criteria? Like Non-Payment due
10 days after end of month - Request for receipt conformation due 15 days
after shippment - etc.
 
C

carrietom

Hi Karl, I guess they do have different criteria. Some due dates have set
time frames (ie. we receive notice and have 30 days to respond). Others, we
request an extension for example, and are given a set due date (not
necessarily based on a certain number of days)
 
K

KARL DEWEY

Please post your table structures.

carrietom said:
Hi Karl, I guess they do have different criteria. Some due dates have set
time frames (ie. we receive notice and have 30 days to respond). Others, we
request an extension for example, and are given a set due date (not
necessarily based on a certain number of days)
 

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

Top