Union Query Syntax Problem

[ebasshead]

Hi Everyone
I have four queries that Ive joined in a union query and want to add a date criteria ei between and including date A and date B. Ive tried a few things but getting errors. Can someone please guide me as to where it should go and how it should be written please. My code so far is below...

SELECT [ArriveDate], [ToProperty], [Flight/Time], [Adults], [Children], [Name], [EisCount], [EisReq],[ArriveTime]
FROM [Transfer Arrive Query]

UNION SELECT [DepartDate], [FromProperty], [Flight/Time], [Adults], [Children], [Name], [EisCount], [EisReq],[DepartTime]
FROM [Transfer Depart Query]

UNION SELECT [DepartDate], [ToProperty], [Flight/Time], [Adults], [Children], [Name], [EisCount], [EisReq],[DepartTime]
FROM [Extra Transfer Depart Query]

UNION SELECT [ArriveDate], [ToProperty], [Flight/Time], [Adults], [Children], [Name], [EisCount], [EisReq],[ArriveTime]
FROM [Extra Transfer Arrive Query]
ORDER BY [ArriveDate],[ArriveTime]

Thank you Eddie

[PianoMan64]

Is there one of these queries that is the master or Parent query or is there another table that ties all these tables together with a common LinkID between each of the tables?

Is this a one to many relationship, if so, can you please explain the structure.

Thanks,

Joe P.