if you say *timestamp* this is hopefully a datetime in your database ....
as a prerequisite you need 2 calenders (or at least 2 sets of dropdown boxes for day, month year), after making sure the end_date is later than the begin_date you add that as WHERE clause to your query ... eg. "SELECT SUM(Amount) AS S FROM tblSales WHERE SalesDate >= " & begin_date & " AND SalesDate < " & end_date & " GROUP BY Year(SalesDate), Month(SalesDate), Day(SalesDate)" ... of course you need to add ORDER BY and a SubSelect for appropriate formatting.
advanced users could also add a WITH CUBE clause for subtotals and you need to write everything into an array which maybe also displays weekday, number of sales, ect ....
depending on your database type you will need to add certain entities to your begin and end date like ' # ... consider also using the datetime function of vb-script
hth, christian
Topic Options
Post Options
Thanks(0)
