Results 1 to 4 of 4

Thread: Quicker way?

  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: Quicker way?

    Whats a quicker way to add 0s instead of blanks to this table without having to do it one column at a time.
    Attached Thumbnails Attached Thumbnails table.JPG  

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Do you need to add zeroes to the table or in a report? In a report you can create calculated textboxes set to something like =Nz([1_01],0). That will display a 0 instead of being blank. You can also do it in a query.

    If you do need to update the table then you can use the same function to add the 0 in place of the null.

  3. #3
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Why not set the record default to 0 (zero) sorts out further records

    then use an update query setting criteria to "" and update to 0

    Gareth...

  4. #4
    Join Date
    Sep 2006
    Posts
    162
    When i import it changes to null from 0s, so default wasn't worken.

    I've done a update query, but i have to do it for every column.

Posting Permissions

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