Re: Do I have to have equal number of records in each table to combine them?

Tech-Archive recommends: Fix windows errors by optimizing your registry

March 2006

SELECT Output_MAR_2006.ID, Output_MAR_2006.New, Output_MAR_2006.[SR #],
Output_MAR_2006.Type, Output_MAR_2006.Area, Output_MAR_2006.[Sub Area],
Output_MAR_2006.Status, Output_MAR_2006.Substatus,
Output_MAR_2006.[Last Name & SSN], Output_MAR_2006.[Last Name],
Output_MAR_2006.[First Name], Output_MAR_2006.[Social Security #],
Output_MAR_2006.Facility, Output_MAR_2006.Owner,
Output_MAR_2006.Source, Output_MAR_2006.Resolution,
Output_MAR_2006.Summary, Output_MAR_2006.[Billing Station],
Output_MAR_2006.[Facility VISN], Output_MAR_2006.Opened,
Output_MAR_2006.Closed, Output_MAR_2006.[Date Assigned],
Output_MAR_2006.[Created By], Output_MAR_2006.[Date Modified],
Output_MAR_2006.[First Closed Date], Output_MAR_2006.Organization
FROM Output_MAR_2006;

Query from the one above to get only records that have the Type of FP
(Below is the one I am trying to combine with the other one that is
below for Feb.) This one has 107,217 records.

SELECT *
FROM [Output_MAR_2006 Query]
WHERE ((([Output_MAR_2006 Query].Type)="FP"));

Febraury 2006

SELECT Output_FEB_2006.ID, Output_FEB_2006.New, Output_FEB_2006.[SR #],
Output_FEB_2006.Type, Output_FEB_2006.Area, Output_FEB_2006.[Sub Area],
Output_FEB_2006.Status, Output_FEB_2006.Substatus,
Output_FEB_2006.[Last Name & SSN], Output_FEB_2006.[Last Name],
Output_FEB_2006.[First Name], Output_FEB_2006.[Social Security #],
Output_FEB_2006.Facility, Output_FEB_2006.Owner,
Output_FEB_2006.Source, Output_FEB_2006.Resolution,
Output_FEB_2006.Summary, Output_FEB_2006.[Billing Station],
Output_FEB_2006.[Facility VISN], Output_FEB_2006.Opened,
Output_FEB_2006.Closed, Output_FEB_2006.[Date Assigned],
Output_FEB_2006.[Created By], Output_FEB_2006.[Date Modified],
Output_FEB_2006.[First Closed Date], Output_FEB_2006.Organization
FROM Output_FEB_2006;


Query from the one above to get only records that have the Type of FP.
This one has 20,408 records.

SELECT *
FROM [Output_FEB_2006 Query]
WHERE ((([Output_FEB_2006 Query].Type)="FP"));

.