writing running sub-totals back into a table

[George Steward]

I have written an Access database to track the accounts of a small trader
which works successfully. The customer has now asked me to include an
additional feature which is described as follows:

A box of assorted goods is purchased for a price and that box is then sorted
and the individual goods are sold, the problem is collecting all the
individual prices together and calculating the profit/loss on the initial
purchase price for the box. this profit/loss will appear in the amendment
form for each item and the original box.

Because I hadn't catered for this scenario originally my profit/loss box
shows a total loss for the original box and a total profit against each item
in that box that is sold.

I want to be able to reflect the running profit/loss for the box against
each individual component and keep it continually updated, the only way I
have found to do it so far is to generate a report and show it that way.

George

[MacDermott]

Re: writing running sub-totals back into a table

I think you'll find that using a report is by far the best way to accomplish
this.

HTH
- Turtle

"George Steward" <gostewa@clara. net> wrote in message
news:1069535240 .84702.0@putney .uk.clara.net.. .[color=blue]
> I have written an Access database to track the accounts of a small trader
> which works successfully. The customer has now asked me to include an
> additional feature which is described as follows:
>
> A box of assorted goods is purchased for a price and that box is then[/color]
sorted[color=blue]
> and the individual goods are sold, the problem is collecting all the
> individual prices together and calculating the profit/loss on the initial
> purchase price for the box. this profit/loss will appear in the amendment
> form for each item and the original box.
>
> Because I hadn't catered for this scenario originally my profit/loss box
> shows a total loss for the original box and a total profit against each[/color]
item[color=blue]
> in that box that is sold.
>
> I want to be able to reflect the running profit/loss for the box against
> each individual component and keep it continually updated, the only way I
> have found to do it so far is to generate a report and show it that way.
>
> George
>[/color]

[George Steward]

Re: writing running sub-totals back into a table

I agree but how do I get the results from the report back onto the form?

"MacDermott " <macdermott@nos pam.com> wrote in message
news:sASvb.1561 9$Rk5.14610@new sread1.news.atl .earthlink.net. ..[color=blue]
> I think you'll find that using a report is by far the best way to[/color]
accomplish[color=blue]
> this.
>
> HTH
> - Turtle
>
> "George Steward" <gostewa@clara. net> wrote in message
> news:1069535240 .84702.0@putney .uk.clara.net.. .[color=green]
> > I have written an Access database to track the accounts of a small[/color][/color]
trader[color=blue][color=green]
> > which works successfully. The customer has now asked me to include an
> > additional feature which is described as follows:
> >
> > A box of assorted goods is purchased for a price and that box is then[/color]
> sorted[color=green]
> > and the individual goods are sold, the problem is collecting all the
> > individual prices together and calculating the profit/loss on the[/color][/color]
initial[color=blue][color=green]
> > purchase price for the box. this profit/loss will appear in the[/color][/color]
amendment[color=blue][color=green]
> > form for each item and the original box.
> >
> > Because I hadn't catered for this scenario originally my profit/loss box
> > shows a total loss for the original box and a total profit against each[/color]
> item[color=green]
> > in that box that is sold.
> >
> > I want to be able to reflect the running profit/loss for the box against
> > each individual component and keep it continually updated, the only way[/color][/color]
I[color=blue][color=green]
> > have found to do it so far is to generate a report and show it that way.
> >
> > George
> >[/color]
>
>[/color]

[MacDermott]

Re: writing running sub-totals back into a table

Design your application so that this information is available from the
report, not the form.

"George Steward" <gostewa@clara. net> wrote in message
news:1069596670 .96535.0@dyke.u k.clara.net...[color=blue]
> I agree but how do I get the results from the report back onto the form?
>
> "MacDermott " <macdermott@nos pam.com> wrote in message
> news:sASvb.1561 9$Rk5.14610@new sread1.news.atl .earthlink.net. ..[color=green]
> > I think you'll find that using a report is by far the best way to[/color]
> accomplish[color=green]
> > this.
> >
> > HTH
> > - Turtle
> >
> > "George Steward" <gostewa@clara. net> wrote in message
> > news:1069535240 .84702.0@putney .uk.clara.net.. .[color=darkred]
> > > I have written an Access database to track the accounts of a small[/color][/color]
> trader[color=green][color=darkred]
> > > which works successfully. The customer has now asked me to include an
> > > additional feature which is described as follows:
> > >
> > > A box of assorted goods is purchased for a price and that box is then[/color]
> > sorted[color=darkred]
> > > and the individual goods are sold, the problem is collecting all the
> > > individual prices together and calculating the profit/loss on the[/color][/color]
> initial[color=green][color=darkred]
> > > purchase price for the box. this profit/loss will appear in the[/color][/color]
> amendment[color=green][color=darkred]
> > > form for each item and the original box.
> > >
> > > Because I hadn't catered for this scenario originally my profit/loss[/color][/color][/color]
box[color=blue][color=green][color=darkred]
> > > shows a total loss for the original box and a total profit against[/color][/color][/color]
each[color=blue][color=green]
> > item[color=darkred]
> > > in that box that is sold.
> > >
> > > I want to be able to reflect the running profit/loss for the box[/color][/color][/color]
against[color=blue][color=green][color=darkred]
> > > each individual component and keep it continually updated, the only[/color][/color][/color]
way[color=blue]
> I[color=green][color=darkred]
> > > have found to do it so far is to generate a report and show it that[/color][/color][/color]
way.[color=blue][color=green][color=darkred]
> > >
> > > George
> > >[/color]
> >
> >[/color]
>[/color]

[George Steward]

Re: writing running sub-totals back into a table

It is already - the customer wants the information on the form she uses to
update the entry such as when there is any chargeable work done on the item
and when it is sold. These must reflect in the profit for the box as a
whole.

"MacDermott " <macdermott@nos pam.com> wrote in message
news:CAbwb.1714 0$Rk5.7015@news read1.news.atl. earthlink.net.. .[color=blue]
> Design your application so that this information is available from the
> report, not the form.
>
> "George Steward" <gostewa@clara. net> wrote in message
> news:1069596670 .96535.0@dyke.u k.clara.net...[color=green]
> > I agree but how do I get the results from the report back onto the form?
> >
> > "MacDermott " <macdermott@nos pam.com> wrote in message
> > news:sASvb.1561 9$Rk5.14610@new sread1.news.atl .earthlink.net. ..[color=darkred]
> > > I think you'll find that using a report is by far the best way to[/color]
> > accomplish[color=darkred]
> > > this.
> > >
> > > HTH
> > > - Turtle
> > >
> > > "George Steward" <gostewa@clara. net> wrote in message
> > > news:1069535240 .84702.0@putney .uk.clara.net.. .
> > > > I have written an Access database to track the accounts of a small[/color]
> > trader[color=darkred]
> > > > which works successfully. The customer has now asked me to include[/color][/color][/color]
an[color=blue][color=green][color=darkred]
> > > > additional feature which is described as follows:
> > > >
> > > > A box of assorted goods is purchased for a price and that box is[/color][/color][/color]
then[color=blue][color=green][color=darkred]
> > > sorted
> > > > and the individual goods are sold, the problem is collecting all the
> > > > individual prices together and calculating the profit/loss on the[/color]
> > initial[color=darkred]
> > > > purchase price for the box. this profit/loss will appear in the[/color]
> > amendment[color=darkred]
> > > > form for each item and the original box.
> > > >
> > > > Because I hadn't catered for this scenario originally my profit/loss[/color][/color]
> box[color=green][color=darkred]
> > > > shows a total loss for the original box and a total profit against[/color][/color]
> each[color=green][color=darkred]
> > > item
> > > > in that box that is sold.
> > > >
> > > > I want to be able to reflect the running profit/loss for the box[/color][/color]
> against[color=green][color=darkred]
> > > > each individual component and keep it continually updated, the only[/color][/color]
> way[color=green]
> > I[color=darkred]
> > > > have found to do it so far is to generate a report and show it that[/color][/color]
> way.[color=green][color=darkred]
> > > >
> > > > George
> > > >
> > >
> > >[/color]
> >[/color]
>
>[/color]