Prikazi cijelu temu
09.07.2013 22:12
09.07.2013 22:12
Predmet:Re: CountIf u accessu?
Napravi tabelu Table1 i unesi ovo u nju.
napravi jednu formu i dva txt polja za datume.
Neka se forma zove Form1. a polja Dat1 i Dat2.
Evo upit:
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]));
Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.