Date Problem

[kaveman]

Hi Everyone,

I am trying to calculate a customers first week worth of revenue using the following on my report:

txtRevFirst = DSum("[AMOUNT_DUE]", "[INVOICES]", "[CUSTOMER_CODE]=[txtCustCode] and [STATE]<>4 and [DATE_OF_INVOICE]<#txtFirstWeek#")

txtFirstWeek is simply the date of the first invoice plus seven days. right now i receive an error message.

i have tried converting txtFirstWeek to a date using many of the methods posted on this site but so far i just keep running into a different array of error messages.

can anyone shed some light on this as to how i should go about formatting so the dsum statement correctly interprets txtFirstWeek as a date?

 

[pbaldy]

http://www.mvps.org/access/general/gen0018.htm