Hello everyone.

Im creating a query for my real estate business. I got the tax records for everyone in my county. Almost 500,000. Im working on joining 6 tables that have one common record.(strap number). 4 tables have the data on one line. 2 tables have the same strap number for 3 or more lines (See below pic.) but different data for the fields.
http://pic4.picturetrail.com/VOL749/2760121/9211561/317577923.jpg


First strap number has three lines. The columns we need are tp and uts.

TP UTS
-------------
Sh 2 Number of Stories 2
Br 3 Number of bedrooms 3
Bt 2 Number of baths 2

What do we put in our query if we want to find a 1 story, 3 bed, 2 bath home? And to have it read out on one line in the query results.

Thanks

Create a totals query that selects only strap and add a count field. For criteria add:
On separate lines under the tp field -
(tp = SH and uts >= 2)
(tp = BR and uts >= 2)
(tp = BT and uts >= 2) but make sure that the select box is unchecked for the tp field. add criteria for the count field three times
= 3
= 3
= 3

The criteria will select any row that matches one of the three criteria sets and the count ensures that three records are selected.

Save this query. then create a second query that joins the first one back to the table so you can select all the columns you need.

Ok I don't understand it. Please explain it to me as I was a rock. I haven't dealt with access since High school. I tried it but get nothing.

Got a different answer that worked thanks any ways.