Recent content by Korp26

how would i send a report from access if a value in the report falls below set point.

Okay that’s easier than my way. Isolating it from the original sting is better. I had done it differently. Seeing yours makes me also see less chance for mistakes, always pulling info from one source. Good stuff.

I’m going to work on this, thanks for the explanation. Helpful..👍🏻

CCT: Mid([Line-1],InStrRev([Line-1]," ")+4)

I have pulled numbers like these from a table and it sorts them 1,10,11... I want them 1,2,3....and so on. Good example 250-HP-1401 CCT1: IN-250-TR-4030-01; IN-250-TR-4031-01 250-HP-1401 CCT2: IN-250-PW-4020-04 Bad example 250-HP-1401 CCT1: IN-250-TR-4030-01; IN-250-TR-4031-01 250-HP-1401...

Sounds good. I have set out to learn ms access. And from the looks of it you all are very helpful. 👍🏻

Hello everyone out there there there..... happy to join today.