Search results

Where do you put the queries that you want to show progress for?

This did it: IIf(InStr([po no],"-")>0,Left([po no],InStr([po no],"-")-1),[po no]) Thanks for the help!!!!!!

iif (instr([po no],"-")>0 , "yes", No") Expression has an invalid string

I tried this to test...what am I missing: iif (instr([po no],"-",1) = >0), "yes", No")

because the field length is different, but ones with dashes have a dash: Mid length - 2. I queried for that and return the base left, then do a summary in query 2

Thanks, I understand points 1 and 2 very well, but unfortunately, it's not my data. I had been using Mid using iif (Mid([po no], len(([po no])-2),1)="-"), left([po no]-2),[po no]) but like I said data mismatch...will instr fix that mismatch?

I have data such as: PO Num Qty 12345 10 12346 20 12345-1 5 12346-1 5 123 7 123-1 3 I want to create a summary count for the base left digits before the -x PO Num Qty 12345 15 12346 25 123 10 I have tried many combos of queries...

I have a long running MDB database that we are porting over to a SQL backend, but that is probably a year down the road. We have been using an MDB-->MDE front end/MDB back end utilizing Access 2003. We are now moving to Access 2016. My plans are to continue with the MDE --> MDB Front / MDB...