Search results

Yes, I'd thought about 'in' but the problem is that the data has been input by someone else and they haven't been consistent so sometimes they have abbreviated the to 3 letters and other times have keyed the full word. I was using the like statement as the first three letters of each type are...

Thanks Plog :) .. I suspected as much.

I was importing some data with some missing fields and basically wanted to say if Field1 is either this or that (there are about 6 or 7 different possible values in field 1) then add x amount, else do nothing (because I was going to have to look up the other instances manually). It works the...

Hi, just a quick question, I wondered if there was a quicker way of doing the following: Expr1: IIf([field1] Like "*criteria1*" Or [field1] Like "*criteria2*",[field2]+20,[field2]) Do I need to be typing the full "or ... like" statement for each criteria or is there another way like putting...

Hi All, just a quick post to introduce myself. My name is Nicky, I am in the UK. I have limited Access knowledge, all self taught. I am about to embark on writing a new client database and thought this forum would be a great source of knowledge and advice to help me along the way :)