I was finally able to get the query to execute, but it took a workaround - two queries.
The Union query named "Query1Sub"
Code:
PARAMETERS [Enter Date:] DateTime, [Enter TheNumber:] Long;
SELECT "YourTable" AS SourceTable, YourTable.YourDate, YourTable.YourNumber
FROM YourTable
WHERE (((YourTable.[YourDate]) Between [Enter Date:]-5 And [Enter Date:]+5))
UNION ALL
SELECT "Cash4Table", YourDate, YourNumber
FROM Cash4Table
WHERE YourDate BETWEEN [Enter Date:]-5 AND [Enter Date:]+5;
UNION ALL
SELECT "GAFiveTable", YourDate, YourNumber
FROM GAFiveTable
WHERE YourDate BETWEEN [Enter Date:]-5 AND [Enter Date:]+5
UNION ALL SELECT "Fantasy5Table", YourDate, YourNumber
FROM Fantasy5Table
WHERE YourDate BETWEEN [Enter Date:]-4 AND [Enter Date:]+5;
And main query named "Query1Main"
Code:
SELECT SourceTable, YourDate, YourNumber
FROM Query1Sub
ORDER BY SourceTable, YourDate;
Open "Query1Main", enter the parameters.......