does anyone have an idea how i could generate a monthly,daily or annual report using sql statement since i have tried with the one for daily and i keep getting the error 'now' is not a recognized function name.
i want to get the total of Amount column and VAT column separately for todays transactions and this is the code i write
pubSQl = "SELECT SUM(AMOUNT) As TotalAmount,SUM(VAT)As TotalVAT from TransactionsToday WHERE DateAdded = 'now'"
when i run it i get the error above.but when i put a specific date like 05/10/2010 it works fine.my aim is to have a daily report,monthly report and annual report command buttons such that when u click it generates the report.
any help is highly appreciated