Search results

No it would be an account that has both, M insurance is primary (pays first) and the X insurance is secondary or pays second. I only want to find accounts that have both insurances in that order. If the account only has one insurance I don't want it or if the account has X insurance primary I...

Ok, this is frying my brain. I'll start by saying I know Access decently, a tiny bit of VBA and SQL that is self taught, and have excellent Google Fu so I can fake it really well. I have a list of accounts and I need to find the ones that have Insurance M (field one = M) as Primary (field two...