Help with update query

[Randy]

MS Access 2000. I need an update query that will update multiple records
[CertNo] with a [dateissued] Example: I have 10 records with a [CertNo] of
"121212" up to this point the [DateIssued] has been null. I now need to
update all these records with a [CertNo] of 121212 with a [Dateissued] of
10/15/09. Thank you.

The criteria for [Dateissued] should be:
[Forms]![frmdateeissued]![Dateissued]
The criteria for [CertNo] should be:
[Forms]![IncomingNotesheet]![CertNumber]

 

[Daryl S]

You are close. Try this in your update query:

The criteria for [CertNo] should be:
[Forms]![IncomingNotesheet]![CertNumber]

The update to for [Dateissued] should be:
[Forms]![frmdateeissued]![Dateissued]

The criteria for [Dateissued] should be:
Is Null

- Daryl S

 

[John Spencer]

Parameters Forms]![IncomingNotesheet]![CertNumber] DateTime;
UPDATE SomeTable
SET [DateIssued] = Forms]![IncomingNotesheet]![CertNumber]
WHERE [CertNo] = Forms]![IncomingNotesheet]![CertNumber]


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County