Predmet:Re: CountIf u accessu?
Napravi tabelu Table1 i unesi ovo u nju.
Datum | Broj | Sig01 | Sig02 | Sig03 | Presig |
---|
41464 | 01-01-02-25/13 | 01 | | 03 | 02 |
41465 | 01-01-02-26/13 | | 02 | | |
41466 | 01-01-02-27/13 | 01 | 02 | | |
41467 | 01-01-02-28/13 | 01 | | | |
41468 | 01-01-02-29/13 | | | 03 | |
41469 | 01-01-02-33/13 | 01 | | | 02 |
41470 | 01-01-02-55/13 | | 02 | | |
41471 | 01-01-02-22/13 | 01 | | 03 | |
napravi jednu formu i dva txt polja za datume.
Neka se forma zove Form1. a polja Dat1 i Dat2.
Evo upit:
PreuzmiIzvorni kôd (SQL):SELECT COUNT(Table1.Sig01) AS Sig_01, COUNT(Table1.Sig02) AS Sig_02, COUNT(Table1.Sig03) AS Sig_03, COUNT(Table1.Presig) AS Pres, COUNT([sig01])+COUNT([sig02])+COUNT([sig03])-COUNT([presig]) AS rez
FROM Table1
WHERE (((Table1.Datum) BETWEEN [Forms]![Form1]![dat1] AND [Forms]![Form1]![dat2]));
Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.