Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Filling in empty fields with 0s

Discussion in 'Information Technology' started by Gina, Jul 28, 2006.

  1. Gina

    Gina
    Expand Collapse
    Guest

    I am using the 'Replace' feature. I put in the

    Replace - Is Null

    With - 0

    When it starts, you can see it fill in all the blanks with 0s, however, it
    never finishes. It ends up telling me 'this database is not responding'.
    Any reason why this would happen each and every time. I can do this in Excel
    with the same data by exporting it and then having to import it back in.
    There are around 85,000+ records.

    Thanks.
    --
    Gina
     
  2. Loading...

    Similar Threads Forum Date
    1984 DSGMC dilly delaying for filling case against Kamal Nath, alleges Phoolka History of Sikhism May 31, 2010
    Kamdhayn/ਕਾਮਧੇਨ & Wish-fulfilling Elysian Tree. Spiritual Articles Jul 20, 2009
    Sikh News BSP accuses Punjab govt of not fulfilling promise (Outlook India) Breaking News Oct 4, 2007
    Fulfilling one's hopes Gurmat Vichaar Jul 5, 2006
    Superbly fulfilling Spiritual Articles Jan 7, 2006

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    First back up your data.

    You can use update query to do this

    UPDATE TableName SET FieldName = 0
    WHERE FieldName Is Null

    --
    Good Luck
    BS"D


    "Gina" wrote:

    > I am using the 'Replace' feature. I put in the
    >
    > Replace - Is Null
    >
    > With - 0
    >
    > When it starts, you can see it fill in all the blanks with 0s, however, it
    > never finishes. It ends up telling me 'this database is not responding'.
    > Any reason why this would happen each and every time. I can do this in Excel
    > with the same data by exporting it and then having to import it back in.
    > There are around 85,000+ records.
    >
    > Thanks.
    > --
    > Gina
     
  4. Gina

    Gina
    Expand Collapse
    Guest

    Thanks for your quick response.

    When I ran the update query, it stated that it updated some 14,000
    records/fields. However, when I went into the table they are still all
    showing blank. I re-ran the update query again, however, this time it says
    it has 0 records to update. It is acting like there are zeros in there, but
    I don't see anything.
    --
    Gina


    "Ofer Cohen" wrote:

    > First back up your data.
    >
    > You can use update query to do this
    >
    > UPDATE TableName SET FieldName = 0
    > WHERE FieldName Is Null
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Gina" wrote:
    >
    > > I am using the 'Replace' feature. I put in the
    > >
    > > Replace - Is Null
    > >
    > > With - 0
    > >
    > > When it starts, you can see it fill in all the blanks with 0s, however, it
    > > never finishes. It ends up telling me 'this database is not responding'.
    > > Any reason why this would happen each and every time. I can do this in Excel
    > > with the same data by exporting it and then having to import it back in.
    > > There are around 85,000+ records.
    > >
    > > Thanks.
    > > --
    > > Gina
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Your table accepts zero length values (ie Null or VBA.vbNullstring) -
    Allways turn of ZLS for Fields - Check www.allenbrown.com for code
    In the mean time modify your query to
    UPDATE TableName SET FieldName = 0
    WHERE FieldName Is Null Or FieldName=""

    HTH

    Pieter



    "Gina" <Gina@discussions.microsoft.com> wrote in message
    news:EA48AC17-B307-42DF-9438-4A9200897831@microsoft.com...
    > Thanks for your quick response.
    >
    > When I ran the update query, it stated that it updated some 14,000
    > records/fields. However, when I went into the table they are still all
    > showing blank. I re-ran the update query again, however, this time it
    > says
    > it has 0 records to update. It is acting like there are zeros in there,
    > but
    > I don't see anything.
    > --
    > Gina
    >
    >
    > "Ofer Cohen" wrote:
    >
    >> First back up your data.
    >>
    >> You can use update query to do this
    >>
    >> UPDATE TableName SET FieldName = 0
    >> WHERE FieldName Is Null
    >>
    >> --
    >> Good Luck
    >> BS"D
    >>
    >>
    >> "Gina" wrote:
    >>
    >> > I am using the 'Replace' feature. I put in the
    >> >
    >> > Replace - Is Null
    >> >
    >> > With - 0
    >> >
    >> > When it starts, you can see it fill in all the blanks with 0s, however,
    >> > it
    >> > never finishes. It ends up telling me 'this database is not
    >> > responding'.
    >> > Any reason why this would happen each and every time. I can do this in
    >> > Excel
    >> > with the same data by exporting it and then having to import it back
    >> > in.
    >> > There are around 85,000+ records.
    >> >
    >> > Thanks.
    >> > --
    >> > Gina
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    ... AND you might want to change the field to a numeric type field ...

    Pieter

    "Gina" <Gina@discussions.microsoft.com> wrote in message
    news:EA48AC17-B307-42DF-9438-4A9200897831@microsoft.com...
    > Thanks for your quick response.
    >
    > When I ran the update query, it stated that it updated some 14,000
    > records/fields. However, when I went into the table they are still all
    > showing blank. I re-ran the update query again, however, this time it
    > says
    > it has 0 records to update. It is acting like there are zeros in there,
    > but
    > I don't see anything.
    > --
    > Gina
    >
    >
    > "Ofer Cohen" wrote:
    >
    >> First back up your data.
    >>
    >> You can use update query to do this
    >>
    >> UPDATE TableName SET FieldName = 0
    >> WHERE FieldName Is Null
    >>
    >> --
    >> Good Luck
    >> BS"D
    >>
    >>
    >> "Gina" wrote:
    >>
    >> > I am using the 'Replace' feature. I put in the
    >> >
    >> > Replace - Is Null
    >> >
    >> > With - 0
    >> >
    >> > When it starts, you can see it fill in all the blanks with 0s, however,
    >> > it
    >> > never finishes. It ends up telling me 'this database is not
    >> > responding'.
    >> > Any reason why this would happen each and every time. I can do this in
    >> > Excel
    >> > with the same data by exporting it and then having to import it back
    >> > in.
    >> > There are around 85,000+ records.
    >> >
    >> > Thanks.
    >> > --
    >> > Gina
     
  7. Gina

    Gina
    Expand Collapse
    Guest

    Ofer,

    I tried this and it didn't work. I also tried Pieter's suggestion, no to
    that also. However, what I was doing was trying to update 5 fields at the
    same time. When I only update one field at a time, it works. Any reason why
    it doesn't like to update multiple fields at a time?
    --
    Gina


    "Ofer Cohen" wrote:

    > First back up your data.
    >
    > You can use update query to do this
    >
    > UPDATE TableName SET FieldName = 0
    > WHERE FieldName Is Null
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Gina" wrote:
    >
    > > I am using the 'Replace' feature. I put in the
    > >
    > > Replace - Is Null
    > >
    > > With - 0
    > >
    > > When it starts, you can see it fill in all the blanks with 0s, however, it
    > > never finishes. It ends up telling me 'this database is not responding'.
    > > Any reason why this would happen each and every time. I can do this in Excel
    > > with the same data by exporting it and then having to import it back in.
    > > There are around 85,000+ records.
    > >
    > > Thanks.
    > > --
    > > Gina
     

Share This Page