Beginning Balance for yearly report

  • Thread starter Thread starter znibk
  • Start date Start date
Z

znibk

How do I compose a query which will pull only the beginning balance of a
particular month, example 9/1/07? I have completed queries which will give me
the income between the time frame after that, but can not seem to acquire
only the beginning balance to add to the income and expenses so an accurate
accounting can be made,

Please,can someone help me complile a query to extract only the begtinning
balance?

Thanks in advance.

k
 
How do I compose a query which will pull only the beginning balance of a
particular month, example 9/1/07?
Click to expand...

That depends entirely upon the structure of your table. Care to describe it so
someone might have a chance to answer?
 
In my table, I have field name of BegBalDate and Data Type of Date/Time. At
the end of the month, I enter the end balance as a beginning balance for the
next month. Ex. 8/31/07 ending balance becomes the beginning balance for
9/1/07. My Qry_BegBal currently has about 16 beginning balance dates and the
corresponding balance for that date.

In the report I want only one particular beginning balance date ex: 9/1/07.

I created a form [Forms]![FrmBegBalDATE]![TxtStart] and then put that as the
criteria as the BegBalDate and it gives me only the one date, but I can't
seem to transfer that information in a way the query will work in the report.

I hope that gives you the information you need and are able to help.

Thanks in advance,

Karen
 
John,
In my post on December 4, 2008, I described my query. I was hoping you or
someone would have looked at it by now and given me some suggestion.

Thanks to whoever takes the time to help me out with this prolem.

Kaen
 
I don't see any post in this newsgroup where you have posted the SQL of a
query or where you have described your table structure.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
John,

Hope you had a very Merry Christmas. On 12/4/08, I described my table as I
am not sure how to give you an SQL view for a table, here is the information
again.
I have:
Field Name: ABANK
Data Type: AutoNumber
Field Name: Bank
Data Type: Number (I have a join query connected to this table)
Field Name: MonthYear
Data Type: Number (Join query connected with this table)
Field Name: BegBalDate
Data Type: Date/Time
Field Name: BegBal
Data Type: Currency

As stated in the December 4, 2008 post, I have approximately 15 beginning
balances with their dates listed in my table. I want to be able to pick just
ONE date with the beginning balance which corresponds to that date.

My query is this:
SELECT tblBANK.Bank, tbl_ARVEST.ABegBalDate, tbl_ARVEST.ABegBal
FROM tblMONTHYEAR INNER JOIN (tblBANK INNER JOIN tbl_ARVEST ON tblBANK.BANKS
= tbl_ARVEST.Bank) ON tblMONTHYEAR.MONTH_YEAR = tbl_ARVEST.MonthYear
GROUP BY tblBANK.Bank, tbl_ARVEST.ABegBalDate, tbl_ARVEST.ABegBal
HAVING (((tblBANK.Bank)="ARVEST Bank") AND ((tbl_ARVEST.ABegBalDate) Between
[Forms]![FrmDates]![TxtStart] And [Forms]![FrmDates]![TxtEnd]));


The ultimate goal is to be able to create a report in which I have the
beginning balance of a certain year, then am able to add the income and
expenses by using
Between [Forms]![FrmDates]![TxtStart] And [Forms]![FrmDates]![TxtEnd])) to
work .

Currently, I am trying to add the begbal and the total income together to
get a total assets.
I have added the total expenses together.

However, I am having difficulty in obtaining the correct ending balance.

When we solve the problem with the beginning balance, I will try and give
you the SQL statement of the Reports and SubReports which I have.

Thank you so much for you time,

Karen
 
Back
Top