Accsess Form
in [Forms]
|
From: Kenj on 22 Jan 2010 00:12 I Have a broblem with this =[Line Total1]+[Line Total2]+[Line Total3] +[Line Total4]+[Line Total5]+[Line Total6][Line Total7]+[Line Total8]+[Line Total9]+[Line Total10]+[Line Total11]+[Line Total12]+[Line Total13]+[Line Total14]+[Line Total15]+[Line Total16]+[Line Total17]+[Line Total18]+[Line Total19]+[Line Total20]+[Line Total21]+[Line Total22]+[Line Total23]+[Line Total24]+[Line Total25] If I dont put data in all the fields I get anything.
From: fredg on 22 Jan 2010 01:28 On Thu, 21 Jan 2010 21:12:01 -0800, Kenj wrote: > I Have a broblem with this =[Line Total1]+[Line Total2]+[Line Total3] > +[Line Total4]+[Line Total5]+[Line Total6][Line Total7]+[Line Total8]+[Line > Total9]+[Line Total10]+[Line Total11]+[Line Total12]+[Line Total13]+[Line > Total14]+[Line Total15]+[Line Total16]+[Line Total17]+[Line Total18]+[Line > Total19]+[Line Total20]+[Line Total21]+[Line Total22]+[Line Total23]+[Line > Total24]+[Line Total25] If I dont put data in all the fields I get anything. Look up the Nz function in VBA help. =Nz([Line Total1],0)+Nz([Line Total2],0) + Nz(etc....) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
From: Piet Linden on 22 Jan 2010 01:16 On Jan 21, 11:12 pm, Kenj <K...(a)discussions.microsoft.com> wrote: > I Have a broblem with this =[Line Total1]+[Line Total2]+[Line Total3] > +[Line Total4]+[Line Total5]+[Line Total6][Line Total7]+[Line Total8]+[Line > Total9]+[Line Total10]+[Line Total11]+[Line Total12]+[Line Total13]+[Line > Total14]+[Line Total15]+[Line Total16]+[Line Total17]+[Line Total18]+[Line > Total19]+[Line Total20]+[Line Total21]+[Line Total22]+[Line Total23]+[Line > Total24]+[Line Total25] If I dont put data in all the fields I get anything. wrap them in Nz([Line Total1])
From: Gina Whipp on 22 Jan 2010 00:21 Kenj, Because you can't add a number to nothing, so we have to account for the nothingness. Each 'Line Total' must be *wrapped* with Nz(), ie... Nz([Line Total1],0) As a side note, a little concerned about your table set up. It looks like you commited spreadsheet with your database. Perhaps if you elaborate we can offer a better solution. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kenj" <Kenj(a)discussions.microsoft.com> wrote in message news:B3F00E67-BF67-46A1-B7DE-3794EF2371CA(a)microsoft.com... >I Have a broblem with this =[Line Total1]+[Line Total2]+[Line Total3] > +[Line Total4]+[Line Total5]+[Line Total6][Line Total7]+[Line > Total8]+[Line > Total9]+[Line Total10]+[Line Total11]+[Line Total12]+[Line Total13]+[Line > Total14]+[Line Total15]+[Line Total16]+[Line Total17]+[Line Total18]+[Line > Total19]+[Line Total20]+[Line Total21]+[Line Total22]+[Line Total23]+[Line > Total24]+[Line Total25] If I dont put data in all the fields I get > anything.
|
Pages: 1 Prev: adding up 1 to 25 fields Line totals to a sub totals Next: Delete duplicates from a table |