Hi Guy's, I probably cant see the wood for the trees here, this looks ok to me but must be missing something, any idea ? note there is definite records within the date criteria
Code:
Dim rs as DAO.Recordset, Dim StartDate As Date, EndDate as Date
StartDate = Forms!frmOutputs!txtStartDate
EndDate = Forms!frmOutputs!txtEndDate
Set rs = CurrentDb.OpenRecordset("Select tblInvoices.InvoiceDate, tblInvoices.InvoiceNumber, tblInvoices.Customer, " _
& "tblInvoices.Qty, tblInvoices.Ref, tblInvoices.Description, tblInvoices.Total, " _
& "tblInvoices.Paid, tblInvoices.PaidDate, " _
& "WHERE InvoiceDate Between #" & StartDate & "# And #" & EndDate & "#")