T
TK
I am having a problem sending this simple WHERE clause in my openreport
command:
DoCmd.OpenReport stDocName, acViewPreview, , , "[InvoiceDate] =#" &
Me.cmbInvoiceDate & "#"
The report comes back with no records - but there are in fact records that
match.
Is my problem that the report is grouped based on the Invoice date - and if
so, how can I get around it?
I have a form which opens when they go to the report menu so they can choose
to print all invoices or just ones for certain dates (still would be all
invoices - just from that date).
Thanks in advance.
TK
command:
DoCmd.OpenReport stDocName, acViewPreview, , , "[InvoiceDate] =#" &
Me.cmbInvoiceDate & "#"
The report comes back with no records - but there are in fact records that
match.
Is my problem that the report is grouped based on the Invoice date - and if
so, how can I get around it?
I have a form which opens when they go to the report menu so they can choose
to print all invoices or just ones for certain dates (still would be all
invoices - just from that date).
Thanks in advance.
TK