Just a few comments:
Why is the
client name in the
job raising table? Should be in the client table.
Shouldn't use punctuation or special characters in object names. (It looks like you have a field name "Cost
+ VAT".)
Shouldn't use spaces in object names. (includes field, table, query, form and report names)
If you MUST separate words use the underscore: "Client name" (bad) would be "
Client_Name" (better) or "
ClientName" (best)
Should never use calculated fields in tables. The calculations should be in a query. See
http://www.allenbrowne.com/casu-14.html
I wouldn't think you would want to select jobs based on start date. If a job started in one month and finished in the next month, it seem to me that that job would never be invoiced.
If you only invioce
finished jobs, maybe use just the "FinishDate".
Something like
Code:
DoCmd.OpenReport "MonthlyInvoice", , , "ClientName = '" & Me.cboClientName & "' AND FinishDate Between #" & BOM & "# AND #" & EOM & "#;"
(BOM = beginning of the month (ie the first)/ EOM = end of the month)
The open report command syntax (as suggested by Paul) is
DoCmd.OpenReport(
ReportName, View, FilterName,
WhereCondition, WindowMode, OpenArgs)