Hi Guy's, this one should be so easy but can't see the woods for the trees
I can't get the characters correct in this recordset ?
Code:Dim mStartDate as Date, mEndDate as Date Set rs = CurrentDb.OpenRecordset("Select tblInvoices.InvoiceDate, tblInvoices.Name, tblInvoices.InvoiceNumber, tblInvoices.CostOfJob, tblInvoices.Paid, tblInvoices.PaidDate From tblInvoices WHERE InvoiceDate Between #" & mStartDate & "#" And " & menddate & #" & " ORDER BY InvoiceDate;")