473,585 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Opening Balance

2 New Member
Hi guys,
How do I go about opening balance (Previous total balance) for my various accounts in my cash flow. I am open to all suggestions
Jan 11 '22 #1
6 14489
457 Recognized Expert Moderator Contributor
Hi Kwabena10
Welcome to the forum.
Please can you provide more details so we understand exactly what you want assistance with
Jan 11 '22 #2
32,566 Recognized Expert Moderator MVP
Hi Kwabena & welcome to Bytes.com.

We need you to understand that a question such as this with so little information - and even sense - is not going to work well either for you or the site. Remember that those reading your question know only what you write.

As that is almost nothing and makes less sense I hope you can understand why you're unlikely to get any expert help unless / until you provide enough information that someone can understand what you want help with.

This is the bare minimum required for questions here so please understand for all future questions.
Jan 12 '22 #3
2 New Member
Thank you for the response, what i want to say was, i have 3 account and under each account there are transaction under them. And i have total balance for each account. What i want is opening balance for each account. The issues is when i select a date range i want to see the total balance from the previous date . Example when i select a date from 1/1/2022 to 10/1/2022 there may be other transactions before the 1/1/2022 but what i have only shows me total balances from that selected range.......... ........
For further clarification you can send me you email for me to send you a sample of the project.

Also how can i group all my account transaction in accordance to quarters (1st quarter thus "January- March, 2nd quarter thus "April - June" , 3rd quarter thus "July - September" 4th quarter thus "October - December".
Jan 14 '22 #4
214 Recognized Expert New Member
Use a union query having two subqueries.

Official guide:
Use a union query to combine multiple queries into a single result
  • The first query sums transactions up to the first date selected
  • The second query selects the transactions within the date range selected

To group by quarters, use:

Expand|Select|Wrap|Line Numbers
  1. Group By DatePart("q", [TransactionDate])
Jan 15 '22 #5
32,566 Recognized Expert Moderator MVP
Hi Kwabena.

In response to your request for an email address - that is a "No" for so many reasons. However, I will start by explaining that what I say is for your education and not meant as chastisement. I understand you're simply finding your way in a new area.

First, and most important, it is quite inappropriate to request email address on a forum from someone you don't know. We, as moderators, would not even allow a reply from anyone without deleting it for their own online safety.

Second, providing a database is simply a way to ensure that you don't need to go to the trouble of writing your question clearly. That is your responsibility. It may seem harsh if that's hard for you - yet why should others have to spend their valuable time simply in order to save the questionner the effort of meeting their responsibility. It would waste time they could otherwise be using to answer questions.

Sometimes an expert will request an illustration. That is the only time it is ever appropriate to include one. It can be dine by Zipping it up and attaching it to a post. No need for email.

I hope I've explained all that clearly. I repeat - this is not to criticise you as clearly you weren't aware - though I would advise checking out a site's rules before starting to use it as a generally wise and considerate thing to do always.

I've also included this publicly so that other interested parties can read this and have some guidance about how to go about getting answers in a good way.

-Ade (Site Administrator).
Jan 15 '22 #6
32,566 Recognized Expert Moderator MVP
Hi Kwabena again.

As for you new question, we generally like to keep only one question to each thread for simplicity of all involved (You can create as many other question threads as you need & there is no set limit). Nevertheless, it seems Cactus has already answered that for you very straightforward ly so we can consider that done.

The main part of your question is still very unclear as you don't include any reliable description of how your data is held, nor even really exactly what it is you're looking for.
  1. Is it a single table with multiple records?
  2. Do you have multiple records spread across different tables?
  3. What exactly are you wanting done with the date range? That's still very unclear.

You will need to make the effort to explain your situation properly if we're to offer helpful advice. This is true of all questions. You have to remember this is not an interactive conversation and we don't know anything at all about your database unless you tell us.
Jan 15 '22 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Greg | last post by:
On my report I want to have an opening balance signifying all transactions up to the month selected and detailed transactions for the month selected and then a closing blance. I'm perpelexed how to do this Anyone knows how the banks do it with statement formatting? suggestions, ideas welcome.
by: Prakash | last post by:
I have 2 tables ... Customer_Master: Cust-Code, Cust_Name Customer_Transactions: Cust_Code, Date, Details, Debit, Credit I would like to generate a report in the foll manner, say from 15.1.06 to 15.02.06 :
by: moyoal | last post by:
Hi, Can anyone help me how to get current opening balance from the table AR_PAYMENT_SCHEDULES any replies will be highly appreciate.... Regards, moyoal
by: Paul H | last post by:
I have a transactions table and a balance table that look something like this: tblTransactions TransactionID (PK Autonumber) ClientID TransactionDate TransactionAmount (currency field, values must be >0) CRDR (indicates whether the transaction is a (credit or debit) StatementDate (Date stamp applied when the “Statement” report is run)
by: eeze | last post by:
Hi Everyone I am very new to access.Can someone help me.I am trying to create a form with a daily Opening balance using sql.My tbl looks like this below.I willbe very grateful. Date Opening Balance Withdrawal Deposit Balance 2008/10/01 73100 23400 0 49700 2008/10/02 49700 13800 ...
by: Muhammad Osma | last post by:
Dear, I am using the Coding for Party Ledger, first i make View in SQL Server and then show on the Crystal Report but i am facing one Problem which is of Opening Balance, how shall i create opening Balance in Report, Kindly help me... I am using this coding for Report. crpled.ReportFileName="D:\shan\Accounts\Reports\ledger.rpt" ...
by: mirajkhanbd | last post by:
I have a repots like sn...date.......description...debit...credit...balance 1....08/15/16...book.............00.......50.......-50 2....08/17/16...pen..............00.......10.......-60 3....08/20/16...deposit.........100.......00.......+40 4....08/25/16...book.............00.......20.......+20 but when I view repots in between date...
by: pmohanty | last post by:
formula for opening balance and closing balance calculation from fiscal year to another fiscal year
by: SheikhAltaf | last post by:
Dear all, I am unable to calculate running Dsum of opening balance of ledger accounts (above 200 ledgers) =Nz(DSum("-","qry_OpeningBalance"),0) this works very well only for single ledger account, but not working for all ledger accounts in report, for example, i want to see ledgers of 2 accounts i.e Capital and Assets 1-Capital Opening...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.