Query

R

Ransom

Hello,
I really hope someone can help me...I am a novice at this....and here is my
problem.

I am attempting to create a database which tracks the spending of a program
I coordinate. What I would like to do is calculate the percent of the money
I have spent. I have a field for cost in my main table. Do I need to add a
program amount field? or can I get around doing this.

Also, I would need help in letting the database track different fund account
numbers...
PLEASE HELP
 
J

John Vinson

Hello,
I really hope someone can help me...I am a novice at this....and here is my
problem.

I am attempting to create a database which tracks the spending of a program
I coordinate. What I would like to do is calculate the percent of the money
I have spent. I have a field for cost in my main table. Do I need to add a
program amount field? or can I get around doing this.
Click to expand...

Ummm...

Yes. If you will be calculating a percentage, you'll be dividing one
number by another number. If you don't have the "program amount" in
your database somewhere then you can hardly divide by it!

I am NOT sure, though, how your tables are structured or what
information you're storing. I would expect at least a table of
Programs, related one-to-many to a table of expenditures for that
program - but that's only a guess.
Also, I would need help in letting the database track different fund account
numbers...
Click to expand...

Then you need another table of Fund Accounts; how this table would
relate to Programs or to Expenditures, you would know better than I!


John W. Vinson[MVP]
 
Top