Tælle record i forespørgsel

DCount Function Example

The following example returns the number of orders shipped to the United Kingdom after January 1, 1995. The domain is an Orders table. The criteria argument restricts the resulting set of records to those for which ShipCountry equals UK and ShippedDate is greater than 1-1-95.

intX = DCount("[ShippedDate]", "Orders", _
    "[ShipCountry] = 'UK' AND [ShippedDate] > #1-1-95#")
In the next example, the criteria argument includes the current value of a combo box called ShipCountry. The values in the ShipCountry combo box come from the field ShipCountry in an Orders table. Note that the reference to the control isn't included in the quotation marks that denote the strings. This ensures that each time the DCount function is called, Microsoft Access will obtain the current value from the control.

intX = DCount("[ShippedDate]", "Orders", "[ShipCountry] = '" _
    & Forms!Orders![ShipCountry] & "'AND [ShippedDate] > #1-1-95#")

Evt.
MsgBox DCount("*", "Forespørgsel")

Ikke rigtig god da resultatet gerne skulle komme i tabel
tabel eksempel
afsnit  tekst
1        tekst1
2        tekst2
3        osv

Det er data i en underformular.

do you want to have a number beside each line?

Ja tak

Do you have a primary key in the table (autonumber)? There MUST be a field which is unique and possible to sort on before you can do this!
If you can send me your dB then I can take a look this evening
eksperten@NOSPAMsanthell.dk
remove NOSPAM

This is a simple example as to how it is done, maybe you can get yours to work from this.

SELECT T1.*, (Select count(*) from a AS T2 WHERE T2.ID < T1.ID)+1 AS Nr
FROM a AS T1
ORDER BY T1.ID;

Jeg har sendt databasen samt lille beskrivelse i word med.
Håber du kan fikse den.

tni

SELECT (Select count(*) from tblDVDindenhold AS T1 WHERE T1.DVDindenholdID < tblDVDindenhold.DVDindenholdID)+1 AS afsnitnr, tblDVDindenhold.DVDindenholdID, tblDVDindenhold.afsnitBeskrivelse, tblDVDindenhold.DVDID
FROM tblDVDindenhold;

mvh og god weekend
Terry

Tja.... Du har gjort det igen.
Takker.

Tænk hvor meget man glemmer når man ikke har arbejdet med access i 1½ år.

Thanks tni :o)

Den gik ikke. Som du kan se i den database som jeg har sendt dig så starter post 2 fra 4. Det er her den skal starte fra 1 igen.

Kan du fikse den?

mvh TNI

I'll take a look asap!

Change the sub forms record source to the followwing SQL.



SELECT (Select count(*) from tblDVDindenhold AS T1 WHERE T1.DVDindenholdID < tblDVDindenhold.DVDindenholdID AND T1.DVDID = Forms![tblDVDcover]![DVDId] )+1 AS afsnitnr, tblDVDindenhold.DVDindenholdID, tblDVDindenhold.afsnitBeskrivelse, tblDVDindenhold.DVDID
FROM tblDVDindenhold;

Yes. Så kører det.

For at løse problemet selv næste gang. Kan du lige forklare hvor T1 kommer ind i billedet.

TNI

Great :o)

T1 is just an alias for tblDVDindenhold Becuase the same table is used in a SUB select its necessary to do this so that it is possible to distinguish between them. Its also easier to write T1 instead of tblDVDindenhold

You can also do this with fields
for example:
.. AS afsnitnr ...

mvh
Terry

nåhr. sådan.ja udtrykket kan hurtigt blive langt.