ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Query Barang
4
Kd_Brg:Master Barang
5
Nm_Brg:Master Barang
6
Satuan:Master Barang
7
Stock_Awal:Master Barang
8
Hrg_Beli:Tabel Beli
9
Hrg_Jual:Tabel Jual
10
11
12
Query Beli
13
Kd_Brg:Tabel Beli
14
Hrg_Beli:Tabel Beli
15
Sum Of Jml:jml (Tabel Beli)
16
17
18
19
20
21
22
Query Jual
23
Kd_Brg:Tabel Jual
24
Hrg_jual:Tabel Jual
25
Sum Of Jml:
jml (Tabel Jual)
26
27
28
29
30
31
QueryPBeli
32
35
Kd_Psk:
Tabel Pembelian
36
Kd_Brg:Tabel Beli
37
Nm_Brg:Tabel Beli
38
Jml:Tabel Beli
39
Satuan:Tabel Beli
40
Hrg_Beli:Tabel Beli
41
Tot_Akhir:
Tabel Pembelian
42
Nm_Pemasok:
Tabel Pemasok
43
Alamat:
Tabel Pemasok
44
45
46
47
48
49
50
QeryPJual
51
No_Bukti:
Tabel Penjualan
52
Tgl_Bukti:
Tabel Penjualan
53
Kd_Plg:
Tabel Penjualan
54
Nm_Perusahaan
:
Tabel Pelanggan
55
Alamat:
Tabel Pelanggan
56
Kd_Brg:Tabel Jual
57
Nm_Brg:Master Barang
58
Jml:Tabel Jual
59
Satuan:Tabel Jual
60
Hrg_Jual:Tabel Jual
61
Tot_Akhir:
Tabel Penjualan
62
63
64
65
66
67
Query Stok
68
Kd_Brg:Master Barang
69
Nm_Brg:Master Barang
70
Satuan:Master Barang
71
Stock_Awal:Master Barang
72
Tot_Beli:
IIf([Query Beli]![Sum Of Jml]<>0;[Query Beli]![Sum Of Jml];0)
73
Tot_Jual:
IIf([Query Jual]![Sum Of Jml]<>0;[Query Jual]![Sum Of Jml];0)
74
Hrg_Beli:Query Beli
75
Hrg_Jual:Query Jual
76
Stok_Akhir:
([Stock_Awal]+[Tot_Beli])-[Tot_Jual]
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102