Hi all,


This may be the wrong group but I need some advice on a SQL statement



I have a database that tacks all sales by date and by product I would like
to run a function to display the products with a summary of the items per

Day for example



Item 01/05/11 02/05/11
03/05/11

=====================================================

VALUE ORANGE JUICE 5 9
10





Is this possible or do I have to use memory location with the reporting
program to handle the dates?



[Non-text portions of this message have been removed]