Correct Syntax For DoCmd

[bidbud68]

Hi please could you let me know the correct syntax to send through 2 strings for the below DoCmd :



DoCmd.OpenReport "Invoices For Month End Emailing", acViewNormal, , "Reservations.ReservationID=" & rstInvoices![Reservations.ReservationID]

The string : "Reservations.ReservationID=" & rstInvoices![Reservations.ReservationID] works fine and its the first string I need then I need to pass another string as well : "Accounts.Date=" & rstInvoices![Accounts.Date]

[pbaldy]

If it's a date field:

"Reservations.ReservationID=" & rstInvoices![Reservations.ReservationID] & " AND Accounts.Date= #" & rstInvoices![Accounts.Date] & "#"

[bidbud68]

Thank you thats great

[pbaldy]

No problem.