Search results

  1. J

    Calculating late fees on aging query

    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...
  2. J

    Help with report criteria expression

    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...
  3. J

    DateDiff between a field and now

    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!!
Top Bottom