I have a query based on a simple table.
In the query one of the rows has a row count function:
SELECT RowCounter(CStr([Item_ItemNumber]) & [DN],False,CStr([Item_ItemNumber]) & [DoorType]) AS RowID, tblTemp1.Item_ItemNumber, tblTemp1.Sets_ItemNumber, tblTemp1.DoorType, tblTemp1.Batch, tblTemp1.Location, tblTemp1.DN, tblTemp1.Result, tblTemp1.ID
WHERE (((RowCounter(CStr([Item_ItemNumber]) & [DN],False,CStr([Item_ItemNumber]) & [DoorType]))=1));
You would imagine that with one row in the table that the row count would be 1 but the query seem to be using a row number from a previous record set where that row was allocated a different number. It's as if it will not let go of that previous number.
Just to save wasting your time I have had very long conversations on EE about why I need row numbers. The purpose is not aesthetical it serves a very specific purpose that is very long winded, too long for this question.