Re: Make the ending balance the next days beginning balance in MS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sorry, I should have been more explicit.

What data structure (fields, data types) are you using as your source?
Since queries, including crosstabs are based on the actual structure, it's
tough to suggest approaches without knowing that (explicit) structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jim McC" <JimMcC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F2CA47C-750B-44DB-AECE-B8B131F3ECB9@xxxxxxxxxxxxxxxx
The numbers are coming from a table. This table is the source for the
crosstab query. The crosstab query has the date as the row heading, name
(Income/Expense) as the column heading, and the amount as a value.

"Jeff Boyce" wrote:

Jim

Where are you getting the numbers from (i.e., what data/table structure
are
you using)?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Jim McC" <Jim McC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A443A29B-2C29-462B-879B-8078CE1AEDAE@xxxxxxxxxxxxxxxx
On a form and report I am trying to make the one days ending balance
appear
as the following days beginning balance (e.g)

Day Beginning Balance Income Expenses Ending Balance
Mon 10 15 5
20
Tue 20 10 15
15
Wed 15 5 15
5
....

I am using a crosstab query to calculate my income and expense column
numbers and I can do the math on the form to get the ending balance,
but I
am
not able to make my ending balance the next days beginning balance.

Thanks for your advice





.