hi, based on a solution given by rob in
http://www.vbforums.com/showthread.php?t=339978

instead of creating a dummy field in query, we could just create a textbox and set the value when the report runs. so, now my report have a numbering column.

thanks rob

VB Code:
  1. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  2.     Static idCounter
  3.    
  4.     idCounter = idCounter + 1
  5.     txtId = idCounter
  6. End Sub