calculating a sum based off of filtered data?

[darcone]

I am creating a reimbursment form. I am trying to make it where the user
inputs certain data and the form fills out the rest. The autofill portion is
a recap section and i am having problems with this part. What i am trying to
do is have the recap section calculate the sum of a specific cost code and
property and than display that in a read only format. But i am having trouble
doing this when ther are more than one cost code or property it just reflect
a grand total for all.
Ex. of what i want. User puts this info in the repeating table

Property Number Amount Cost Code
0002 $20 01050
0002 $13 01050
0002 $10 01105
0001 $5 01105

I want another table to display this information automatically in a
differnet format such as.

Property Number Cost Code Amount
0002 01050 $33
0002 01105 $10
0001 01105 $5

Where it sums up the total for cost code 01050,01105 for property 0002
seperatly and property 0001 total seperate. Each is on its own line

Thank you for any help

 

[Kevin Spencer]

What exactly is the nature of the trouble?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
You can lead a fish to a bicycle,
but it takes a very long time,
and the bicycle has to *want* to change.

 

[Stefan B Rusynko]

You need a Database solution and custom server side scripting

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I am creating a reimbursment form. I am trying to make it where the user
| inputs certain data and the form fills out the rest. The autofill portion is
| a recap section and i am having problems with this part. What i am trying to
| do is have the recap section calculate the sum of a specific cost code and
| property and than display that in a read only format. But i am having trouble
| doing this when ther are more than one cost code or property it just reflect
| a grand total for all.
| Ex. of what i want. User puts this info in the repeating table
|
| Property Number Amount Cost Code
| 0002 $20 01050
| 0002 $13 01050
| 0002 $10 01105
| 0001 $5 01105
|
| I want another table to display this information automatically in a
| differnet format such as.
|
| Property Number Cost Code Amount
| 0002 01050 $33
| 0002 01105 $10
| 0001 01105 $5
|
| Where it sums up the total for cost code 01050,01105 for property 0002
| seperatly and property 0001 total seperate. Each is on its own line
|
| Thank you for any help

 

[darcone]

Currently is calculating everything and if i change the property number or
cost code it does not creat a new row. If i put in more than 1 cost code it
gives me the grand total for everything not based on cost code.