Help with update query

  • Thread starter Thread starter Randy
  • Start date Start date
R

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]
 
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
 
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
 
Back
Top