autonumbering according to yes/no field

  • Thread starter Thread starter randys
  • Start date Start date
R

randys

I an entering conference registrations into Access. Some
people are eating lunch, some are not. I have a yes/no
field for lunch. Can the form be set to autonumber ONLY
the entries that indicate yes on lunch...without skipping
numbers?
 
What would you use for a record number on the others?

If you are simply trying to count the number of lunches you need, you should
use a sum query to count the number of Yes's.

Rick B


message I an entering conference registrations into Access. Some
people are eating lunch, some are not. I have a yes/no
field for lunch. Can the form be set to autonumber ONLY
the entries that indicate yes on lunch...without skipping
numbers?
 
Back
Top