calculating a sum based off of filtered data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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.
 
Back
Top