Home Forums Microsoft Access Microsoft Access Incremental Number RE: Incremental Number

  • November 30, 2012 at 2:52 pm

    #1564583

    SELECT DMax("[AssetNumber]","Waste Hauler Number","+1") AS Expr1 FROM [Waste Hauler Number];

    I am getting two 4001. What I am doing incorrectly? I have 4000 and 4001