Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Broj redova u report-u

[es] :: Access :: Broj redova u report-u

[ Pregleda: 2165 | Odgovora: 1 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

bojan_mil
Bg

Član broj: 74014
Poruke: 100
*.dynamic.sbb.rs.



Profil

icon Broj redova u report-u07.10.2009. u 09:51 - pre 176 meseci
Kreirao sam report na osnovu query-a, sve lepo radi. Potrebno mi je da na kraju ispisa svih redova u reportu , ubacim koliko (broj) redova koji se nalazi na reportu.
Hvala...
 
Odgovor na temu

Srbin do jaja

Član broj: 219428
Poruke: 80
*.ptt.rs.



+2 Profil

icon Re: Broj redova u report-u07.10.2009. u 10:28 - pre 176 meseci
Count([OrderID]) Uses the Count function to display the number of records in the current query.

Count(*) Uses the Count function to count the number of records in the query, including records with Null (Null: A value you can enter in a field or use in expressions or queries to indicate missing or unknown data. In Visual Basic, the Null keyword indicates a Null value. Some fields, such as primary key fields, can't contain Null.) (blank) fields.

DCount("[ShippedDate]", "Orders", "[ShipCountry] = '" & strCountry & _ "' AND [ShippedDate] > #" & dteShipDate & "#") Returns the number of orders in the Orders table that were shipped to a specified country/region (strCountry) after a specified ship date (dteShipDate). The domain is the Orders table.
Nemam pojma šta da stavim u potpis!
 
Odgovor na temu

[es] :: Access :: Broj redova u report-u

[ Pregleda: 2165 | Odgovora: 1 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.