Search results

  1. J

    Create an auto-increment field

    Hi, Thanks for your help. The code does create a number for each new record but I only want a number when a certain condition is met, in this case the "credit card" tickbox is checked.
  2. J

    Create an auto-increment field

    Hi, Thanks for the help. I'm pretty new to Access so I'm still struggling a little. I've attached a screen shot of the query design where I'm hoping to put the auto-increment code. Could you take a look and advise accordingly. Thank you
  3. J

    Create an auto-increment field

    I have a table contain PO details which includes a Yes/No box entitled "CC". I have created the form with all relevant fields but need an additional field which when the "CC" field is ticked creates a number starting at 1 and incrementing by 1 every time a new record is added and "CC" is ticked.
Back
Top Bottom