Query Multiple Filter

[QuickQuery?]

Hi All new guy with hopefully a quick question. My Access skills = Sux and I'm very new to it so any advice offered I'll thank you in advance.




I have 2 tables in the query joined by a unique id field in both tables.

The query shows 5 columns, specifically:
one building id fields
building address from table 1
building address from table 2
building status from table 1
building status from table 2

I have the following filter criteria in the "building address from table 1" area <>[building address from table 2]

This effectively shows me all building ids, addresses and statuses (active/inactive) where the address don't match in each table.

What I would like to do within the same query is add an additional filter that eliminates any of the above results where the two building statuses are already the same, with that value being "Inactive". Because if both tables already show that the building is Inactive any address update would not be needed. Is there anyway to do this?

[June7]

Are the status fields text type?

Create a field with calculation

BothInActive: IIf([building status from table 1] = "InActive" AND [building status from table 2] = "InActive", True, False)

Criteria under that constructed field: False

[QuickQuery?]

Are the status fields text type?

Create a field with calculation

BothInActive: IIf([building status from table 1] = "InActive" AND [building status from table 2] = "InActive", True, False)

Criteria under that constructed field: False

They are text


I will try it, thx

[QuickQuery?]

Ahhhh Freakin' SWEEEEET. Thanks so much June7 it works perfectly. I would have never thought to try such a thing.

PM Me your email and I'll send you a coffee

[June7]

Make that a margherita and we're even.

Glad it worked.