Amt sum < certain date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a query that contains an Invoice Amt field and a Invoice Date
field. The invoice date field has a criteria to display only the invoice
amounts that are within user input dates. Both fields come from the same
table. I want both these computations and then would like to add the
following:

Now what I'm trying to do is get a sum of the invoice amts for the date that
is < beggining user inputed date.
<[Forms]![report_date_range]![beggining_date]

Would anyone know how I would go about doing this?

Any help is appreciated.
 
Use two queries. The first to gather the data based on the criteria, the
second to perform the aggregate.

Have the parameter in the first query.
 
Back
Top