|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by MachoLinKz in Delphi Database, SQL Query Syntax
i have 2 crosstab query in access file (mdb) that i want to link using "UNION ALL" query
but the problem is, each crosstab query has static date range
how can i change that date range via delphi programming ?
or
is there another way i can make a crosstab query and add 1 Total row containing the sum of all rows above it ?
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
|
Crosstab 1
TRANSFORM Count(kartu.kartu_id) AS CountOfkartu_id
SELECT kartu.ghost
FROM (progress INNER JOIN kartu ON progress.type_progress=kartu.progress_akhir) INNER JOIN master_sales ON kartu.sales_id=master_sales.sales_id
WHERE (((kartu.kartu_date)<=#10/9/2023# And (kartu.kartu_date)>=#10/10/2009#))
GROUP BY kartu.ghost
PIVOT progress.type_progress;
Crosstab2
TRANSFORM Count(kartu.sales_id) AS CountOfsales_id
SELECT kartu.kartu_id
FROM (progress INNER JOIN kartu ON progress.type_progress = kartu.progress_akhir) INNER JOIN master_sales ON kartu.sales_id = master_sales.sales_id
WHERE (((kartu.kartu_date)<=#23/10/09# And (kartu.kartu_date)>=#10/10/09#))
GROUP BY kartu.kartu_id
PIVOT kartu.progress_akhir;
|
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625
