J jackal575 New member Local time Today, 16:33 Joined Feb 12, 2005 Messages 8 Feb 12, 2005 #1 how do i lookup the amount of records in a table so that it can be attached to a variable
P pono1 Registered User. Local time Today, 00:33 Joined Jun 23, 2002 Messages 1,179 Feb 12, 2005 #2 The easiest way is to use the DCount function. Code: Dim MyRecCount as Long MyRecCount = DCount("AFieldName","TableName") Another way: a recordset. Searching on recordcount here and in your Help file should yield some examples. Regards, Tim
The easiest way is to use the DCount function. Code: Dim MyRecCount as Long MyRecCount = DCount("AFieldName","TableName") Another way: a recordset. Searching on recordcount here and in your Help file should yield some examples. Regards, Tim
