Why not do a select MAX (field name here), add one to that number, then insert it along with the rest of the information? Or am I reading the question wrong?

  ----- Original Message -----
  From: Robert Orlini
  To: CF-Talk
  Sent: Friday, January 02, 2004 12:27 PM
  Subject: counter

  Anyway to increment a number to a field when a new record is inserted? I want to keep a counter of the number of records.

  Robert (HWW)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to