Timestamp

[Tara]

Okay, I could swear I just saw something about this on
here in the last day or two...but after searching, I've
given up finding it! I need to timestamp a table when it
is updated. I've never done this and have no clue how to
go about it. Basically I have several queries set up
that indicate which "packet" of info we send out to our
clients monthly. Depending on several factors, they
either get A, B, Or C. All clients are held in one table
with different fields for indicating if each packet was
sent to them. Currently I have these fields set
to "Yes/No", and update using an update query. However,
I now need to timestamp rather use Yes/No every time they
receive a packet. They will only receive each packet
one time. How do I accomplish this?

Thanks!

 

[Guest]

I don't think MS-Access can automatically update a field with a timestamp (as SQL Server can do). You can do it manually by adding a Date/Time field to the table and including the "SET Field = Now" expression in your UPDATE statement as follows

UPDATE Table1 SET TStamp = Now, ..
WHERE ..

The Now() function always returns the current system date and time


----- Tara wrote: ----

Okay, I could swear I just saw something about this on
here in the last day or two...but after searching, I've
given up finding it! I need to timestamp a table when it
is updated. I've never done this and have no clue how to
go about it. Basically I have several queries set up
that indicate which "packet" of info we send out to our
clients monthly. Depending on several factors, they
either get A, B, Or C. All clients are held in one table
with different fields for indicating if each packet was
sent to them. Currently I have these fields set
to "Yes/No", and update using an update query. However,
I now need to timestamp rather use Yes/No every time they
receive a packet. They will only receive each packet
one time. How do I accomplish this

Thanks