Search results

I know. I changed it but I tried it with the date first and it still has the same problem. if you choose another (future) date, it goes back to 01

I did and checkd it on your db

in the code you put Date, not DateofPurchase so as it happens all the inputs you gave have the same date (today) and they go ascending. Try using another date (if you choose a future date it will work) and you will see it goes to 01

I already did that is what I'm saying. did this also. Still no way to circumvent the 01 option though :(

I changed it to LotNumber :D It still starts from 01 for every new date. But also I cancelled the Locked function because if I get ingredients from other suppliers I need to put their lot numbers.

no difference

if i change the date it goes back to 01. it shouldn't do that. it should keep on going from the previous lot regardless of the date

same no luck :(

still the same I think this line is the problem:

I put it in the beforeUpdate and I locked the lotnumber However, it still goes to 01 for any new date

now it keeps the - and it ascends properly but it goes back to 01 if I change date. I was thinking it should continue on and keep the previous number. Or shouldn't it?? I really don't know what's the best option

I had 4 inputs already, but it starts from 01 again. Also, after 01, it loses the - and then everything it puts is 02, no matter how many lines I add PS. I made it to add a - after the supplyID (here 016-)

So I need to format a cell to create lot numbers. I want it to be the SupplyID-Date-Ascending number I have figured how to get the first two parts, but the last part needs to be an ascending number for every different ingredient, so I can't use the lot autonumber for instance. For example, I...

It works perfectly!! thank you!

one problem Can you make these numbers not appear 0? Because I can't have it show like that on the actual receipt Or in the retail It generally rounds it up or down ( beats me how, 7,18 doesn't make 8) But I don't want it rounded

you made it!! it works!! wow you are a magician! Now I just need to understand what you did. what is this dbl command?

either ProductDeatilT but recognise what price it is or get Price from OrderDetailsQ which runs an IIF command

I tried this. It doesn't work properly So the first time you add a product it recognises if it's wholesale or retail and it adds that price But every time after you add it it takes that first price. Which is a mess if you change orders from retail to wholesale and vice versa. Try adding orders...

Well I'll try this one next and see how it goes. Rest well for now