Recent content by julie417

Thanks pr2-eugin....I'm afraid I'm behind you on the learning curve. I haven't reached learning about modules. I can't get this to work (my fault). :o

Hi JHB 30_60_90: IIf(IsNull([datepaid]),IIf(DateDiff("d",[invoicedate],Date())<30,"Current",IIf(DateDiff("d",[invoicedate],Date()) Between 31 And 60,"30 Days",IIf(DateDiff("d",[invoicedate],Date()) Between 61 And 90,"60 Days","90 Days"))),"")

Hi! I've searched through the threads and can't find anything similar to my problem. Hope I'm not repeating :) Am running a query based on Accounts Receivable table. I want a field that will show late fees based on 30 days, 60 days and 90 days past due. The fields I am working with are...

Hello! I am trying to create a report from a query. The query is based on invoices. In my report, I want it to only show invoices between certain dates, but not all invoices. Here is what I've entered as the criteria expression: [InvoiceDate] =>[05/15/2013] And =<[08/10/2013] I...

Thanks Eli.....this worked perfectly!

Brian - Next time I will keep track of what I tried. I tried so many I couldn't tell you!

Hello, I would like to count the days between [InvoiceDate] and Now, but I keep getting messages that either I have the wrong number of arguments or I am missing brackets/parenthesis/vertical bar. Can someone help me write this expression???? Thanks!!