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
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
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar