Record Set with between dates

[Guest]

Hi everybody
I want to write record set which will extract all the Invoices from table
Invoice where DVNo is equal to the DVNo on the form and date is between the 2
dates from the Startup form, I dont have date field on my form where I'm
searching the Invoice Nos. my record set is some how like this please correct
this:

Set rst = db.OpenRecordset("SELECT InvoiceNo,Date FROM Invoices WHERE
[StoreIssueNo]= &StoreIssueNo& and Date Between [forms]![Startup Dialog
Form]!#[BeginningDate]# and [Forms]![Startup Dialog Form]!#[EndingDate]#")

Thanks

 

[Naresh Nichani MVP]

Hi:

Try this --

Set rst = db.OpenRecordset("SELECT InvoiceNo,Date FROM Invoices WHERE
[StoreIssueNo]= " & StoreIssueNo & " and Date Between #" &
[forms]![Startup Dialog
Form]![BeginningDate] & "# and #" & [Forms]![Startup Dialog
Form]![EndingDate] & "#")

The variables should be outside the quotes and you should concatenate the
string with &.

Regards,

Naresh Nichani
Microsoft Access MVP