I'm using Access 2010 and I have a form which I'd like to filter data.
I have two fields: ACCOUNT + CPYCODE
And I'd like to filter the data so we end up with:
CPYCODE = 12 - 14
ACCOUNT = Not
like: A00090, A00091, A00092, A00093, A00094
I doubt a string of 'ACCOUNT not like' is the best way to do it, and I don't think my use of ( ) is correct either:
DoCmd.ApplyFilter , "(CpyCode = '12') or (CpyCode = '13') or (CpyCode = '14') and Account not like 'A00090'"
Can anyone help me achieve what I'm trying to do?