Hi All,
I need to determine the line number of a range of records in a query
I use the below code
#LineNo: DCount("*","Mate=rialNo","QTY<=" & [QTY])#
I presume I can use any control in the table that is a number field to do the count?
I used QTY as this is the only number field I have in this table
I have 12 records in this selection but my line number for each record is 15
any explanation why?
I need to determine the line number of a range of records in a query
I use the below code
#LineNo: DCount("*","Mate=rialNo","QTY<=" & [QTY])#
I presume I can use any control in the table that is a number field to do the count?
I used QTY as this is the only number field I have in this table
I have 12 records in this selection but my line number for each record is 15
any explanation why?