I'm trying to pull a report from POS about which item was sold on which day (and time). Fields to include are date, skew, item name, department and price. So far I can pull sale by day, but not the items that were sold on that day or I can pull which item was sold on a day, but not break that by date. As I'm analyzing several years of information, I would like a comprehensive report instead of pulling each day for the last three years. I realize that the run time for the report will be extensive but I can set it to run over a weekend when we are not open to the customers.