I'm new at this and need the help of the experts, im trying to make a query using the following;
Table = CUSTABLE1
FIELDS: cus_name, cus_id, pur_date, sales_type, sales_total,
Make a query to export the fields above listing only when pur_date is between 1/1/16 – 1/31/16. Also
Sales_type stores 2 different characters “a” and “b” . Can these be put in 2 different columns suming the sales_total of each?