Hi
I built this and it works in excel but i have no idea on how to get it to work in an access query?
The [@Details] field is the field Import.Details
Please help.
Thanks
Rob
I built this and it works in excel but i have no idea on how to get it to work in an access query?
Code:
=IF(ISNUMBER(SEARCH("Training",[@Details])),"#TRNG",IF(ISNUMBER(SEARCH("Leave",[@Details])),"#HOLS",IF(ISNUMBER(SEARCH("holiday",[@Details])),"#HOLS",IF([@Details]="","#Free",IFERROR(TRIM(LEFT(SUBSTITUTE(REPLACE([@Details],1,FIND("#",[@Details])-1,"")," ",REPT(" ",LEN([@Details]))),LEN([@Details]))),"No #")))))
The [@Details] field is the field Import.Details
Please help.
Thanks
Rob