"Does Not Equal" in expression builder

[caringsharingbristolbilly]

Hi to all you kind kind people in MrExcel.comland.

This is a really simple question, but one my brain (which has been replaced by Silly Putty ) is unable to extract from the help files.

If I want to do an expression which compares two text columns, and reports the following conditions:

(a) Column 1 does not equal column 2
AND
(b) Either of the two columns is blank, while the other isn't

...I can't use the <> function, apparently, as that only uses condition (a).

I'm sure it's dead easy, so any non-VB related help would be much appreciated (my VB knowledge doesn't extend past the Australian imported lager of the same name).

Much obliged,
CSBBB

 

[caringsharingbristolbilly]

Sorry. What's an unmatched query? It doesn't seem to be what I'm trying to do.

Right. You'll have to forgive me, I have a stinking cold and my brain isn't working, and I really don't want to be here, and I really really really don't want to be titting around with these wretched tables. So, I'm going to ask you to spell it out for me. I'm really sorry.

What exactly do I need to do to do 4 queries, each of which compares two columns in the two tables and reports how many rows differ between those two columns, either because one is blank and the other isn't, or because both have something in but are different.

I feel really terrible about being so demanding, what with you being so kind 'n' all, but I'm really not working properly today.

Thanks thanks thanks...

 

[Joe4]

From the Queries object menu, click on "New" and select "Find Unmatched Query Wizard". Access will then step you through the whole process in a very user friendly manner.