hi all am trying to obtain a daily report from my database using the code below but it keeps giving me an error of false,when i say debug.print. when i say rptETR.show it gives me all the transactions and not the daily transactions.below is the code
Private Sub Cmddaily_Click()
Dim pubsql As String
pubsql = "SELECT * FROM table1 WHERE transaction_date " = "09/23/2010"
can anyone please help me. if u have an idea how i would go about showing the monthly and annual report please share it with me. thanks in advance
thanks Andre, this seems to work since the error false is no longer there bt i still cannot see the report.when i replace the debug.print with rptetr.show it still displays the whole report,any suggestions on what might be wrong? thanks