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
6 14446
Hi Kwabena10
Welcome to the forum.
Please can you provide more details so we understand exactly what you want assistance with
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.
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".
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).
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. - Is it a single table with multiple records?
- Do you have multiple records spread across different tables?
- 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.
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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"....
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
| |