B blioux Registered User. Local time Yesterday, 19:13 Joined Sep 10, 2002 Messages 14 Dec 6, 2002 #1 anyone know how to make a sequence number that increases by 1 every 200 records. I'm stuck and it seems like such a simple thing. thanx Jason
anyone know how to make a sequence number that increases by 1 every 200 records. I'm stuck and it seems like such a simple thing. thanx Jason
W WayneRyan AWF VIP Local time Today, 00:13 Joined Nov 19, 2002 Messages 7,122 Dec 6, 2002 #2 Jason, You can open a recordset with all records with the same sequence number, do a .MoveFirst, MoveLast and then use rst.RecordCount. Or look up the DCount function. Why are these bundled in groups of 200? Wayne
Jason, You can open a recordset with all records with the same sequence number, do a .MoveFirst, MoveLast and then use rst.RecordCount. Or look up the DCount function. Why are these bundled in groups of 200? Wayne
crosmill Registered User. Local time Today, 00:13 Joined Sep 20, 2001 Messages 285 Dec 9, 2002 #3 If your codeing it....... Open your recordset While NOT rs.EOF n = n + 1 If n = 200 Then n1 = n1 +1 n = 0 End If rs.MoveNext Wend (but give your variables meaningful names)
If your codeing it....... Open your recordset While NOT rs.EOF n = n + 1 If n = 200 Then n1 = n1 +1 n = 0 End If rs.MoveNext Wend (but give your variables meaningful names)
Mile-O Back once again... Local time Today, 00:13 Joined Dec 10, 2002 Messages 11,316 Dec 10, 2002 #4 Why are these bundled in groups of 200? Click to expand... Probably doing some sort of search function showing next 200 results or something.
Why are these bundled in groups of 200? Click to expand... Probably doing some sort of search function showing next 200 results or something.
