Hello! I am having issues in MS Access.. It is stating with the below code I have "Syntax error in union query". Any help is appreciated!

$($SELECT

$[$Date$],$

$[$Category$],$

$[$CategoryDescription$],$

$[$ItemNumber$],$

$[$ItemDescription$],$

$[$County$],$

$[$Sales$])$

From $[$Iowa$\_$Liquor$\_$Sales$\_52216]$

ORDER BY $[$Date$]$;

UNION ALL

$($SELECT

$[$Date$],$

$[$Category$],$

$[$CategoryDescription$],$

$[$ItemNumber$],$

$[$ItemDescription$],$

$[$County$],$

$[$Sales$])$

From $[$Iowa$\_$Liquor$\_$Sales$\_52306]$

ORDER BY $[$Date$]$;

UNION ALL

$($SELECT

$[$Date$],$

$[$Category$],$

$[$CategoryDescription$],$

$[$ItemNumber$],$

$[$ItemDescription$],$

$[$County$],$

$[$Sales$])$

From $[$Iowa$\_$Liquor$\_$Sales$\_52337]$

ORDER BY $[$Date$]$;

UNION ALL

$($SELECT

$[$Date$],$

$[$Category$],$

$[$CategoryDescription$],$

$[$ItemNumber$],$

$[$ItemDescription$],$

$[$County$],$

$[$Sales$])$

From $[$Iowa$\_$Liquor$\_$Sales$\_52358]$

ORDER BY $[$Date$]$;

UNION ALL

$($SELECT

$[$Date$],$

$[$Category$],$

$[$CategoryDescription$],$

$[$ItemNumber$],$

$[$ItemDescription$],$

$[$County$],$

$[$Sales$])$

From $[$Iowa$\_$Liquor$\_$Sales$\_52747]$

ORDER BY $[$Date$]$;

UNION ALL

$($SELECT

$[$Date$],$

$[$Category$],$

$[$CategoryDescription$],$

$[$ItemNumber$],$

$[$ItemDescription$],$

$[$County$],$

$[$Sales$])$

From $[$Iowa$\_$Liquor$\_$Sales$\_52772]$

ORDER BY $[$Date$]$;