Z
zonybel
Hello,
I'm wondering if any of you can help me. I'm designing a simple Data base
were I can manage my department's budget. I have created three tabels one
indicate all our department codes, the second indicate our expenditure codes,
and the third indicates de expenses and allocations per department. I have
created queries that pull all transactions per department. Now I'm trying to
create two more queries. One that calculates the the sum of allocations
minus de sum of expenses per expenditure code per department. and the second
one that can give me a sumary of allocations and expenses per month per dept.
I am 100% sure this is doable because I have seen it on another dababase but
when I copied the formula on mine it didn't work. Can Anyone help me?? My
table has the following fields:
tblEXPENSES
Date, Index, Expenditure Code, Vendor, Description, Allocation, Expenses
tblINDEX (this is the departments table)
Index, Fund, Title
Both of my tables are related by the index field
On the first query I would like to see all the transactions listed with a
sum of allocation, sum of expenses an a grand total which is sum of
allocation minus sum of allocations.
The second query I would like to see a summary (sum of all allocations and
expenses per month) of each index of its allocations and expenses per month.
Hopefully I didn't make it so complicated and any of you are able to help me.
I'm wondering if any of you can help me. I'm designing a simple Data base
were I can manage my department's budget. I have created three tabels one
indicate all our department codes, the second indicate our expenditure codes,
and the third indicates de expenses and allocations per department. I have
created queries that pull all transactions per department. Now I'm trying to
create two more queries. One that calculates the the sum of allocations
minus de sum of expenses per expenditure code per department. and the second
one that can give me a sumary of allocations and expenses per month per dept.
I am 100% sure this is doable because I have seen it on another dababase but
when I copied the formula on mine it didn't work. Can Anyone help me?? My
table has the following fields:
tblEXPENSES
Date, Index, Expenditure Code, Vendor, Description, Allocation, Expenses
tblINDEX (this is the departments table)
Index, Fund, Title
Both of my tables are related by the index field
On the first query I would like to see all the transactions listed with a
sum of allocation, sum of expenses an a grand total which is sum of
allocation minus sum of allocations.
The second query I would like to see a summary (sum of all allocations and
expenses per month) of each index of its allocations and expenses per month.
Hopefully I didn't make it so complicated and any of you are able to help me.