How can I create one query from multiple queries (12 of them) in access? - TechRepublic
Question
February 24, 2011 at 12:53 AM
wmoyonsana

How can I create one query from multiple queries (12 of them) in access?

by wmoyonsana . Updated 15 years, 4 months ago

I have 12 queries with 4 same fields 1 different field in each query. Like this:
(1) -districtID, FacilityID, AssessmentAreaID, AssessmentTypeID, TotalANCStds
(2) -districtID, FacilityID, AssessmentAreaID, AssessmentTypeID, TotalNLDStds
How do i create my union query to come up with one query with all total fields included?

This discussion is locked

All Comments