Recent content by Magnus1982

E.q. SN:1234TTT-1234BTY0001 SN:1234TTT-1234BTY0002 SN:1234TTT-1234BTY0003

Number is long . It have almost 30 characters . Include leters ,digit, and specialist characters as : . Last four position we talking about there are starting from 0001 and rising up

It is not that easy. Imagin you have target 300. You taking scaner and you scaning serial numbers. Serial numbers are mixed then when you will scan 300pcs you dont know how many grups with following numbers was created. Problemy my example was confusing. The idea is that VBA or query will...

This only example. Numbers do not in create all the time. Some Times is a gap between them . I need to catch first number from seqence. For example I am płacing serial number in to data base and the product is splited for bach. First batch is from 1 to 24 and second start from 72 till 138...

Sry Aaa1 and Aaa6 need to be transfered

Hello Forum, During my work with access I am struggle with problem I'm In My Knowledge is not Enough. I have guery with specialist number in one column . Let's say Aaa001 Aaa002 Aaa003 Aaa004 I need to transfer on raport only numbers which are first in number grup. Example: Aaa001 Aaa002...

It is working :) CDate(REPLACE([p1ok],".","/")) It was the solution :) Thank you very much

Hello, For confirmation I am sending pic with query settings and output. I am not sure why but in all query formula i need use ";" if I am using , I have fault On my personal laptop where I have Access2016 is working . When I copy database on pendrive and after on business laptop where i have...

sry not working

Hello. Basiclly column p1 is long text "Test End: 20.08.2018". P1ok using middle function to cut this text . After cut I have 20.08.2018. And this is imput for CDate

Input in p1ok is exqmple : 20.06.2018

Hello, Strange situation In query i have CDate(Format([p1ok];"00000000")) - which should convert string from p1ok column to date . It is working on 2016 Access. When I copied to access 2010 is not working and is showing error in this column Anybody know why ??

Thank you everyone for help. All done !!!

sample now :)

sample: