I can write this function easily in excel but very hard in access.
Some table like this:
_______________ _______________ _______
ID | IN | OUT | SALDO |
-------------------------------------
1 | 1000 | 0 | 1000 |
2 | 1000 | 0 | 2000 |
3 | 0 | 500 | 1500 |
4 | 3000 | 0 | 4500 |
and if the table is mess please look at the image...
yosiro
Last Activity: Jan 20 '17, 06:57 AM
Joined: Aug 31 '12
Location:
-
How to update table with query in simple accounting
-
the query result is not what i want to show like the first post -
Count Unique Data in Separate Field?
Tabel
---------------------------------------------
ID | YEAR | FIELD1 | FIELD2 | FIELD3
---------------------------------------------
1 | 2015 | A | B | D
2 | 2015 | B | C | D
3 | 2016 | C | C | D
4 | 2016 | C | C | A
5 | 2016 | C | A | B
How to make a query table... -
@ADezii
It's work for me now. ThanksLeave a comment:
-
there is a warning "Characters found after end of SQL statement"Leave a comment:
-
How to make query with multiple count?
There are 3 tables:
scoreT
-----------------------
id_score | id_name | score
1 | 1 | 350
2 | 2 | 400
3 | 3 | 450
4 | 4 | 330
5 | 5 | 500
nameT
------------------------
id_name | name | id_country
1 | Bill | 1
2 | Ana... -
It works, but i want to add 1 column in the query, presented the year after the Total columnLeave a comment:
-
Add criteria from counting more than 2 field
Am sory if the title is not matching with this question.
I have 2 table and 1 query, like this picture below:
The query said:
And i want to show the result of query just in year 2016, how to code this query?Code:SELECT A1, (SELECT COUNT(C1) FROM Table1 WHERE Table2.ID=Table1.C1 OR Table2.ID=Table1.C2) AS Total FROM Table2;
Am sory for my bad english,... -
I change the code from jForbes to my latest post, thanks man its work
Code:SELECT A1 , (SELECT COUNT(C1) FROM Table1 WHERE Table2.ID=Table1.C1 OR Table2.ID=Table1.C2) AS Total FROM Table2
Leave a comment:
-
Am sory to make confuse coz my bad english, am from indonesia.
I want to revision about table 1. here's the image:
And this is the file : https://www.dropbox.com/s/mzszyt120i...se1.accdb?dl=0
So i want to create query that can count total of each Group of Table 2 in Table 1. I hope you are get it what i mean....Leave a comment:
-
Count different 2 field in 1 table at Access Query
I have 2 table, below:
Tabel1
-------------------
ID C1 C2
-------------------
1 QQ QB
2 QB QC
3 QC QB
4 QC QQ
5 QC QQ
6 QC QB
7 QQ QC
8 QC QQ
9 QC QB
10 QQ QB
Tabel2
----------
ID A1
----------
1 QQ
2 QB
3 QC
So i want to create a query like this:
... -
It's done now. I'm making a receipt from this database. Negative number for debit transaction so I can count each group report with sum function not (group a - group b) because there is no standard function for that. Thanks jforbesLeave a comment:
-
Thanks Jforbes, its work, but the "negative" word is now show in the field, like picture attached, can it be removed?...Leave a comment:
-
How to Convert Currency or Negative Numbers into Words?
I have a module to convert numbers (in positive value) into My Language (indonesian) words below:
...Code:Option Compare Database Public Function ubah_terbilang(xbil As Double) Dim nilai, i, j, k, hasil$, HasilAkhir$, Bilangan#, Digit, Rp$, Bil$ If IsNull(xbil) Then ubah_terbilang = Null Exit Function End If 'pengelompokan Dim Kel$(1 -
The problem is solved right now. I have delete my old corrupt database then i create a new one. Lol, thanks zmbdLeave a comment:
-
How to repair accdb file
I work with Access 2010. I work from flashdisk and then the power was blackout. When i returned to open the file from flashdisk, my file (accdb) is not recognized and i think it was corrupt. So i try find software to fix this problem i find "stellar". Unfortunately the file is not good anymore. How to fix it?
Thanks -
Yes you right, but how to return a negative for those that have id 2?Leave a comment:
-
How to subtract 2 field in an Access Report?
How to subtract 2 field in report like the picture below? The Access just have some option like sum, average, min, max, etc, but not subtract.... -
After some experiment i am succeed find that formula, thanks master zmbd
Code:Epr = DAvg("[score]","Query_Student","[city]='Texas'")Leave a comment:
-
sorry,can you write that function likebecause am too newbie for programming :(Code:=DAvg([score]..........??
Leave a comment:
No activity results to display
Leave a comment: