Reakce na odpověď

SELECT KLIENTI.OBEC as bydlisko, Count(KLIENTI.OBEC) AS Pocet_klientov
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.OBEC;

SELECT Count(TRANSAKC.CAS) AS Pocet_dopoledne
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
HAVING (([cas]<=12));

SELECT Year([DATUM_NAR]) AS rok, Count(Year([DATUM_NAR])) AS pocet
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY Year([DATUM_NAR]);

SELECT Month([DATUM_NAR]) AS rok, Count(Year([DATUM_NAR])) AS pocet
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY Month([DATUM_NAR]);

SELECT KLIENTI.MENO, UCase([PRIEZVISKO]) AS UCPRIEZ, KLIENTI.DATUM_NAR, KLIENTI.OBEC
FROM KLIENTI
GROUP BY KLIENTI.MENO, UCase([PRIEZVISKO]), KLIENTI.DATUM_NAR, KLIENTI.OBEC;

SELECT KLIENTI.OBEC, Sum(TRANSAKC.SUMA) AS SumOfSUMA
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.OBEC, TRANSAKC.VKLAD
HAVING (((TRANSAKC.VKLAD)=Yes));

SELECT KLIENTI.MENO, KLIENTI.PRIEZVISKO, Month([DATUM_NAR]) AS mesic, KLIENTI.OBEC
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO, KLIENTI.PRIEZVISKO, Month([DATUM_NAR]), KLIENTI.OBEC
HAVING (((Month([DATUM_NAR]))=5));

SELECT KLIENTI.CISLO_UCTU, KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.PSC
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.CISLO_UCTU, KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.PSC, Right([psc],2)
HAVING (((Right([psc],2))="01"));

SELECT KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.DATUM_NAR, KLIENTI.OBEC, TRANSAKC.VKLAD, Sum(TRANSAKC.SUMA) AS SumOfSUMA
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.DATUM_NAR, KLIENTI.OBEC, TRANSAKC.VKLAD
HAVING (((TRANSAKC.VKLAD)=Yes));

SELECT KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.DATUM_NAR, (Date()-[datum_nar])/365 AS vek
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.DATUM_NAR, (Date()-[datum_nar])/365
HAVING ((((Date()-[datum_nar])/365)<40));

SELECT Count(TRANSAKC.VKLAD) AS CountOfVKLAD
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY TRANSAKC.VKLAD
HAVING (((TRANSAKC.VKLAD)=Yes));

SELECT KLIENTI.MENO, KLIENTI.PRIEZVISKO, Count(TRANSAKC.VKLAD) AS CountOfVKLAD
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO, KLIENTI.PRIEZVISKO, TRANSAKC.VKLAD
HAVING (((TRANSAKC.VKLAD)=Yes))
ORDER BY Count(TRANSAKC.VKLAD) DESC;

SELECT KLIENTI.MENO, KLIENTI.PRIEZVISKO, Sum(TRANSAKC.SUMA) AS SumOfSUMA
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO, KLIENTI.PRIEZVISKO, TRANSAKC.VKLAD
HAVING (((TRANSAKC.VKLAD)=No))
ORDER BY Sum(TRANSAKC.SUMA);

SELECT KLIENTI.MENO
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO;

SELECT KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.DATUM_NAR, KLIENTI.OBEC, (Date()-[datum_nar])/365 AS vek
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.DATUM_NAR, KLIENTI.OBEC, (Date()-[datum_nar])/365
HAVING (((KLIENTI.OBEC)="Bratislava") AND (((Date()-[datum_nar])/365)<30));

SELECT TRANSAKC.CISLO_UCTU, KLIENTI.HESLO
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY TRANSAKC.CISLO_UCTU, KLIENTI.HESLO, Len([heslo])
HAVING (((Len([heslo]))<5));

SELECT TRANSAKC.CISLO_UCTU, KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.HESLO
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY TRANSAKC.CISLO_UCTU, KLIENTI.MENO, KLIENTI.PRIEZVISKO, KLIENTI.HESLO, Len([heslo])
HAVING (((Len([heslo])) Is Null));

SELECT KLIENTI.MENO, KLIENTI.PRIEZVISKO, Sum(TRANSAKC.SUMA) AS SumOfSUMA
FROM KLIENTI INNER JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU
GROUP BY KLIENTI.MENO, KLIENTI.PRIEZVISKO, TRANSAKC.VKLAD
HAVING (((TRANSAKC.VKLAD)=Yes))
ORDER BY Sum(TRANSAKC.SUMA);

SELECT TRANSAKC.CISLO_UCTU, KLIENTI.MENO, KLIENTI.PRIEZVISKO, Sum(TRANSAKC.SUMA) AS SumPlus, Sum(TRANSAKC_1.SUMA) AS sumMinus, [sumplus]-[summinus] AS stav
FROM TRANSAKC AS TRANSAKC_1 RIGHT JOIN (KLIENTI LEFT JOIN TRANSAKC ON KLIENTI.CISLO_UCTU = TRANSAKC.CISLO_UCTU) ON TRANSAKC_1.CISLO_UCTU = KLIENTI.CISLO_UCTU
GROUP BY TRANSAKC.CISLO_UCTU, KLIENTI.MENO, KLIENTI.PRIEZVISKO, TRANSAKC.VKLAD, TRANSAKC_1.VKLAD
HAVING (((Sum(TRANSAKC.SUMA))>0) AND ((Sum(TRANSAKC_1.SUMA))>0) AND ((TRANSAKC.VKLAD)=Yes) AND ((TRANSAKC_1.VKLAD)=No))
ORDER BY [sumplus]-[summinus] DESC;

edit: názvy polí si uprav podle zadání. Nijak jsem to neoptimalizoval.

edit2: Ověřovací pravidla se používají při vstupu dat, nikoli při tvorbě dotazů.

MS Access - potrebujem dopisat overovacie pravidla