Missing Dates

[Keith]

There are certain records I create which are open and shut. That is,
we don't put a completion date in that record. I would like to
automate this and with certain records, take the date created field
and place that date in the completion field. Any suggestions?

[Wayne Morgan]

Re: Missing Dates

Use an Update Query. Set the Date Completion field equal to the Date Created
field where Date Completion Is Null. Add any other criteria you need.

--
Wayne Morgan
MS Access MVP


"Keith" <kodiak33@earth link.net> wrote in message
news:8cd96ae6.0 410071000.25fcf 1e0@posting.goo gle.com...[color=blue]
> There are certain records I create which are open and shut. That is,
> we don't put a completion date in that record. I would like to
> automate this and with certain records, take the date created field
> and place that date in the completion field. Any suggestions?[/color]

[Larry Linson]

Re: Missing Dates

An update query, replacing the completion date with the date created field
on records selected by a criteria of Null should do what you want. After you
create a select query in the query builder, on the menu, Query | Update.

Larry Linson
Microsoft Access MVP

"Keith" <kodiak33@earth link.net> wrote in message
news:8cd96ae6.0 410071000.25fcf 1e0@posting.goo gle.com...[color=blue]
> There are certain records I create which are open and shut. That is,
> we don't put a completion date in that record. I would like to
> automate this and with certain records, take the date created field
> and place that date in the completion field. Any suggestions?[/color]