I may not fully understand the need for serial numbers, but it seems to me that if you calculate the number in a query, the results will be different depending on the where clause. If you need the same record to always have the same serial number, regardless of the selection criteria, then wouldn't it be better to have an auto-increment field in the table itself?