Hi Bud, I just wrote a response which I lost to a python error on the yahoo website. Here's the abbreviated version:
1: IsNull() is a VBA function 2: IS NULL is native SQL Use the second one where you can, because it's faster. Jet looks for the null values itself, rather than passing the task on to VBA. Here's your SQL: UPDATE tblTable SET zip_code = "30512" WHERE zip_code IS NULL; However, if the field is a numeric type, then do not include the quote characters. For more info, search MS Access help with the keywords: update query Good luck, Peter Hoogenboom --- In [email protected], "Bud Blubaugh" <[EMAIL PROTECTED]> wrote: > > I have a table that has many null fields and I want to replace them > with say a zip code of 30512. How do I write the query? > something like: > if zip_code - ISNULL then 30512 or something like that? > Can I use the search/replace window ?? > Thanks, > Bud >
