Results 1 to 6 of 6

Thread: Automatic zeros in table??

  1. Nov 20th, 2000, 02:29 PM #1
    jeffro
    jeffro is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253

    Question

    Ok, I have tried everything. I'm trying to put zeros within 3 fields from my table. I have used an update query 'in the update part I put 0 and in the criteria part I put Is Null'. I have also tried putting Is Null Or "" in the criteria. None of the above has worked for me. Does anyone have any other ideas besides putting the zeros in myself. Lord knows I don't want to do that!

    Thanks jeffro
    Reply With Quote Reply With Quote
  2. Nov 20th, 2000, 03:43 PM #2
    Lafor
    Lafor is offline
    Fanatic Member
    Join Date
    Aug 2000
    Posts
    617

    ...

    what is type of these fields?

    send your update query...

    Make it a good day!
    Reply With Quote Reply With Quote
  3. Nov 20th, 2000, 04:01 PM #3
    jeffro
    jeffro is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253
    The fields types are just numbers. Like this 0.00.

    Do you have any email address for me to send the update query?

    Thanks jeffro
    Reply With Quote Reply With Quote
  4. Nov 20th, 2000, 04:01 PM #4
    Lafor
    Lafor is offline
    Fanatic Member
    Join Date
    Aug 2000
    Posts
    617

    ..

    [email protected]
    Reply With Quote Reply With Quote
  6. Nov 20th, 2000, 04:49 PM #5
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    UPDATE TABLE tablename SET fieldname=0.00 WHERE fieldname IS NULL

    Would that work?
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    Reply With Quote Reply With Quote
  7. Nov 20th, 2000, 04:53 PM #6
    jeffro
    jeffro is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253
    No sorry parksie. I just tried what you suggested and it didn't update any of the rows.

    Thanks for trying!

    jeffro
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width