T
traceyd
I'm stuck and I would greatly appreciate some help with a
problem I have with a subform calc I admit i'm a novice
when it comes to this and just need some help from the
professionals.
I have an 'orders' form with an 'order detail' subform
where you select products. I have a yes/no field which
you select if the product is part of an offer. Then I
have a field which totals all the offers and works out
what % I need to change the unit price by to reflect the
new unitprice. Against each record in the subform I
recalculate the value the newrate should be which is
working fine, I just can't get it to overwrite the
original unitprice field. It's driving me insane and
I've spent about two whole days just trying to get it to
work.
I need to sort this before I can go any further with my
development.
I thank you all in advance for helping me.
problem I have with a subform calc I admit i'm a novice
when it comes to this and just need some help from the
professionals.
I have an 'orders' form with an 'order detail' subform
where you select products. I have a yes/no field which
you select if the product is part of an offer. Then I
have a field which totals all the offers and works out
what % I need to change the unit price by to reflect the
new unitprice. Against each record in the subform I
recalculate the value the newrate should be which is
working fine, I just can't get it to overwrite the
original unitprice field. It's driving me insane and
I've spent about two whole days just trying to get it to
work.
I need to sort this before I can go any further with my
development.
I thank you all in advance for helping me.