473,288 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

Opening Balance

2 2Bits
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 14446
isladogs
454 Expert Mod 256MB
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
NeoPa
32,554 Expert Mod 16PB
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
Kwabena10
2 2Bits
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
cactusdata
214 Expert 128KB
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
NeoPa
32,554 Expert Mod 16PB
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
NeoPa
32,554 Expert Mod 16PB
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 straightforwardly 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

3
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...
2
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...
2
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
3
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...
2
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...
0
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...
1
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...
1
by: pmohanty | last post by:
formula for opening balance and closing balance calculation from fiscal year to another fiscal year
3
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,...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.