rosebud289
Programmer
How do you find and replace null values in Access tables? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Replacing Null Values 1
- Thread starter rosebud289
- Start date
- Status
-
1
- #2
ProgramError
Programmer
UPDATE tblOARequests SET tblOARequests.Printed = -1
WHERE (((tblOARequests.Printed) Is Null));
this changes it to yes or true
Program Error
Programmers do it one finger at a time!
WHERE (((tblOARequests.Printed) Is Null));
this changes it to yes or true
Program Error
Programmers do it one finger at a time!
ProgramError
Programmer
'tbloarequests' should be changed to the name of the table and 'printed' should be the filed . sorry I grabbed it straight out of my database
Program Error
Programmers do it one finger at a time!
Program Error
Programmers do it one finger at a time!
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
