dcount

[kevcar40]

Hi
i have a table containing thee fields
index
name
Surname

on a form i have an index number attached to another table shownin a
textbox "serial"

what i want to do is count the number of records matching the serial
number on the form

e.g.

Form serial number = 480

the table names has 2 names with serial number 480
the answer should be 2

=DCount("index","Names") this count of all the records


= DCount("index","Names",where index = me.serial)

how do i get i to return only the number required?

thanks

kevin

 

[Tom van Stiphout]

On Fri, 9 May 2008 02:18:45 -0700 (PDT), kevcar40

= DCount("index","Names", "index = " & me.serial)

-Tom.