Help with update query

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]
 
D

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help prevent report from running 1
Update query, cant get it to work 2
Dcount - Criteria 3
Multiple Report Filter using form 1
Simple Query/Date issue (I Hope) 2
Date Query 3
Help with report query 17
Make a table 1

Top