Beginning Balance
Experts,
Is it possible to do what I want in the picture?
I need to use the [BegBal] as the [FacilityAggregate]
I dont know if Access can do this within a qry.
Please see pic.
Any other questions please let me know.
The name of the qry is qryLCIssuedFacExpireByMont
thank you
testBegBal.accdb
Is it possible to do what I want in the picture?
I need to use the [BegBal] as the [FacilityAggregate]
I dont know if Access can do this within a qry.
Please see pic.
Any other questions please let me know.
The name of the qry is qryLCIssuedFacExpireByMont
thank you
testBegBal.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did not completley understand the significance of non normalized data?
Your data is not presented in a non-normalized fashion in your screenshots, and Access has a difficult time working with data like that. Your data is far more suited to a spreadsheet (i.e. "flat file", or non-normalized) sort of storage system, where you CAN define a "preceding line". Database are used to store financial data all the time, but in many cases, that data is extracted to a spreadsheet-type of a UI in order for the users to make the best use of the data.
As long as you ONLY need to view this data, then of course you'd use a report, as suggested by boag. Access can easily "flatten" this data, and even present you with running totals/sums etc, using the builtin reporting engine. Only when you have the requirement for users to EDIT this data does the trouble come into play.
As long as you ONLY need to view this data, then of course you'd use a report, as suggested by boag. Access can easily "flatten" this data, and even present you with running totals/sums etc, using the builtin reporting engine. Only when you have the requirement for users to EDIT this data does the trouble come into play.
ASKER
I see.
LSM, I have a question...very short. I am here at work now and ran the query qryLCIssuedFacExpireByMont
I get this input box for FacilityBalance and not sure why.
The formula is here:
FacilityBalance: Format([FacilityAggregate]
The only thing I can think of is because the FAcilityAggregate and SsetToExpireThisMonth are also manual type of formulas. But the odd thing is that I just hit enter for the msgboxes and I get my results and I dont believe whatever I input in the box makes a difference.
I dont know if it is because the "Total" row (the Group By option) should be something else such as "Expression" but I tried and still get the msgbox.
Do you know why I would get the msgbox? If not a quick answer then dont mind about it please. I know there are better things to do...:)
thank you
LSM, I have a question...very short. I am here at work now and ran the query qryLCIssuedFacExpireByMont
I get this input box for FacilityBalance and not sure why.
The formula is here:
FacilityBalance: Format([FacilityAggregate]
The only thing I can think of is because the FAcilityAggregate and SsetToExpireThisMonth are also manual type of formulas. But the odd thing is that I just hit enter for the msgboxes and I get my results and I dont believe whatever I input in the box makes a difference.
I dont know if it is because the "Total" row (the Group By option) should be something else such as "Expression" but I tried and still get the msgbox.
Do you know why I would get the msgbox? If not a quick answer then dont mind about it please. I know there are better things to do...:)
thank you
Just to be fair, I have seen queries to do what you are asking, but IMHO, I would still rather just use a Report.
(I guess you could Google: "Query Declining Balance"
...or "Query Running Sum")
If only for the fact that these queries tend to get more complex as your recordset complexity increases.
...Especially if this is just for display purposes.
But again, for whatever reason, some people just want/need to use a query.
So I made my initial post just in case...
I see that LSM actually contributed more to this thread than I did, ..I have no issue with you changing this to give him all the points.
;-)
Jeff
(I guess you could Google: "Query Declining Balance"
...or "Query Running Sum")
If only for the fact that these queries tend to get more complex as your recordset complexity increases.
...Especially if this is just for display purposes.
But again, for whatever reason, some people just want/need to use a query.
So I made my initial post just in case...
I see that LSM actually contributed more to this thread than I did, ..I have no issue with you changing this to give him all the points.
;-)
Jeff
ASKER