Search results

They do not need to be contiguously numbered, the solution provided is perfect. Thanks so much

Awesome thank you so much!

Save me manual entry. I need it to generate UPCs. Every product requires a unique UPC and this number would help me get that for every product I make. I can enter them manually on an excel sheet after an export, but I just wanted to know if it was possible and to keep everything in access.

No just a unique number starting at 1, then 2, etc. The number will not repeat, it will be unique. Not date related No constraints

Hi All, Im starting a candle company and have 2 tables: 1 table tblCandleSize Fields: CandleSize (The full spelling of said size, Small, Medium, etc..) CandleSizeSku (S for Small, M for Medium, etc..) 1 table tblCandleScent Fields: CandleScent (The full spelling of said scent)...

Okay amazing thanks, I see how it works now! Thanks a lot. IIF([StartLocation]=1 and [Stop2]=2,250,IIF([StartLocation]=1 and [Stop2]=3,500,0)) The above does exactly as I was looking for, so I should be good to go on and finish my formula now thanks a bunch again. I will post again if I hit...

Hello, First time poster, I searched the forums and tried to apply my situation / formula to others who had similar questions, but I get the #error output with no messages from access telling me what I did to cause this. What I'm trying to do is create a formula that checks if two conditions...