Need help with calculating a field and bringing data over to the next record

[ChingghisKhan]

Hi,



Can someone please help me with the following two issues:

1.) I need the formula to calculate 15% in a new field from an an existing field.
Something like: =([15%] of [price])

2.) How can I get some fields to show automatically on the next record?

Thanks for all your help!

Robert

[June7]

Calculation in query could be simply

Discount: [price] * 0.15

Pulling value from another record of same table requires subquery or domain aggregate function. Review this for subquery method http://allenbrowne.com/subquery-01.html#AnotherRecord