ACCESS FEED: RE: [MS_AccessPros] Require balance on each row of report

Jumat, 27 Desember 2013

RE: [MS_AccessPros] Require balance on each row of report

Khalid,

I would try using the Nz() function. Also, consider changing the names of your text boxes to names that make sense. IMO, there is no excuse for not making the expressions self-documenting.

Duane Hookom MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: khalidtanweerburrah@yahoo.com
> Date: Fri, 27 Dec 2013 12:20:47 -0800
> Subject: Re: [MS_AccessPros] Require balance on each row of report
>
>
>
> Hi All,
> Thanks Duane, you are right we have to move like a team and be in touch
> with each other. I'm sorry for me previous way of communication. That
> is absolutely marvellous Duane.
>
> Now only one thing is left in it although its right, if you see the
> image under Consignment No 2013-B-10 there is only one blank row under
> column Packages Delivered its null value as no packages have been
> delivered yet for this Consignment, therefore in Totals: sum of
> packages Delivered is a null value and Packages Balance (Text60) is
> also a null value, which is:
>
> Text58 Control Source: =[Count Of CartonNo]
> Text59 Control Source: =Sum([NoOfCartons])
> Text60 Control source: =[Text58]-[Text59]
>
> so can i get here digit "Zero" also if i have some other Consignment No
> with the same situation.
> I am uploading new image after making changes which you suggested and worked.
>
> Thanks a lot.
> Khalid
>
>
>
>
>
> On Friday, December 27, 2013 7:32 PM, Duane Hookom
> <duanehookom@hotmail.com> wrote:
>
> Khalid,
>
> Consider not addressing questions to a specific individual. Thank the
> individual and ask help from the team.
>
> Try create a text box [txtDelivRunSum] in the detail section with a
> control source of PackagesDelivered and set it's Running Sum property
> to over group. This will show values of: 24, 30.
>
> Then use a text box under the Packages Balance column with a Control
> Source of:
> =[Your header balance text box] - txtDelivRunSum
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: khalidtanweerburrah@yahoo.com
>>
>> Hi Duane,
>>
>> I was in touch with John for my following issue, but perhaps he is busy
>> in his some activities and do not have time to look into it now. But
>> here my boss needs this issue to be resolved as soon as possible.
>> Therefore i'm requesting you to please look into it for a solution.
>>
>> I have a report on which i need balance on each row under Label
>> "Packages Balance", for some Consignments there may be one row and for
>> some there may be more than one row as "packages delivered" quantity
>> vary for different delivery dates.
>>
>> To let you have an idea of reports output i have uploaded image of the
>> report in groups "2_AssistanceNeeded" folder today. After viewing the
>> image any information you require i will answer you.
>>
>> I have also given details in my previous thread "Totals on Report
>> Footer". in my last post.
>>
>> Looking ahead for your help.
>> Khalid
>
>
>
>
>