Add a date field to multible records days later?

[Randy]

I need to add a date to a [DateIssued] field, but it could be 2 to 7 days
later before I know this information. I am going to maintain records for up
to seven days and then I will create a summary for up to 200 records during
this period. I need to go back and add the [Date Issued] on the date the
summary is created. Could be 2,3,4,5,6 or 7 days later. How can I do this
without having to go back and enter this one by one?...Thanks for any
help...Randy

 

[Allen Browne]

An Update query is the easiest way to update records in bulk.

Assuming you want to set all the records that are blank to today's date:
UPDATE [YourTableName] SET [DateIssued] = Date() WHERE [DateIssued] Is Null;

You could RunSQL that statement, or you could create a query and paste it
into SQL View.

 

[Jeff Boyce]

Randy

It sounds like you could have multiple rows entered, and only some of those
rows needing to get a [DateIssued] update. If so, how would YOU (forget
Access for a second) know which ones needed to get updated?

Or are you saying "if a row doesn't have a value in DateUpdated, put this
date in"? If so, that's much simpler. An update query, with the criterion
of "Is Null", lets you update the 'empty' ones.

Good luck

Jeff Boyce
<Access MVP>

 

[Jeff Boyce]

Kerman

Take a look at Allen's suggestion again, and include a criterion for your
[CertificateNumber] value.

Good luck

Jeff Boyce
<Access MVP>