Update table with query type?

[John]

Hello,

I am a little rusty since it has been a few years but I am needing some help
to get in the right direction.

I have appended data from 2 tables to create a purchase order table with all
the information needed from each. The due date field may change depending on
the supplier delivery date. I am wanting to retain the original due date but
also have the current / revised date as well. How can I store this
information in the table?

Any help to get me in the right direction would be greatly appreciated.

Thanks,

John

 

[John W. Vinson]

I have appended data from 2 tables to create a purchase order table with all
the information needed from each. The due date field may change depending on
the supplier delivery date. I am wanting to retain the original due date but
also have the current / revised date as well. How can I store this
information in the table?

If you need two dates, you need two fields: OriginalDueDate and DueDate.

It should not be necessary to keep the same data around in multiple tables,
though!

 

[John]

John,

I agree but like I said it has been awhile... My reason for doing this is to
be able to pull the original date back up for later reporting on delivery
performance. But how would I have both the original in the table with the new
one?

 

[John]

John,

I agree but like I said it has been awhile... My reason for doing this is to
be able to pull the original date back up for later reporting on delivery
performance. But how would I have both the original in the table with the new
one?

 

[John W. Vinson]

John,

I agree but like I said it has been awhile... My reason for doing this is to
be able to pull the original date back up for later reporting on delivery
performance. But how would I have both the original in the table with the new
one?

Ummm...

What I said.

Modify the structure of your table so that you have two fields, one named
DueDate and one named OriginalDueDate.

If you will have *multiple* duedates, then you may need a one to many
relationship to a DueDates table instead.

The bottom line is that if you want to store two different pieces of
information, you need a place for each of them; if your current structure does
not provide such a place then you need to change the structure!