Answer Happy

I have an access database with six tables. In each table there
is a date column and a Sale (Dollars) column. I need to create a
query that pulls that information from each table for those two
columns so that I can create and run a report on total sales by
month. I am running into problems creating the query.
lowa_Liquor Sales_52216 X Relationships X lowa_Liquor Sales_52216 Invoice/Item Number Date Store Number Store Name Address City Zip Code County Category Category Name Vendor Number Vendor Name Item Number Item Description Pack State Bottle Cost State Bottle Retail Bottles Sold Sale (Dollars)1 Sale (Dollars) lowa_Liquor Sales_52306 Invoice/Item Number Date Store Number Store Name Address City Zip Code County Category Category Name Vendor Number Vendor Name Item Number Item Description Pack State Bottle Cost State Bottle Retail Bottles Sold Sale (Dollars) lowa_Liquor Sales_52337 Invoice/Item Number Date Store Number Store Name Address City Zip Code County Category Category Name Vendor Number Vendor Name Item Number Item Description Pack State Bottle Cost State Bottle Retail Bottles Sold Sale (Dollars) lowa_Liquor Sales_52358 Invoice/Item Number Date Store Number Store Name Address City Zip Code County Category Category Name Vendor Number Vendor Name Item Number Item Description Pack State Bottle Cost State Bottle Retail Bottles Sold Sale (Dollars) lowa_Liquor Sales_52747 Invoice/Item Number Date Store Number Store Name Address City Zip Code County Category 2 Category Category Name Vendor Number Vendor Name Item Number Item Description Pack State Bottle Cost State Bottle Retail Bottles Sold Sale (Dollars) lowa_Liquor Sales_52772 Invoice/Item Number Date Store Number Store Name Address City Zip Code County Category Category Name Vendor Number Vendor Name Item Number Item Description Pack State Bottle Cost State Bottle Retail Bottles Sold Sale (Dollars)