Amt sum < certain date

[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.

 

[[MVP] S.Clark]

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.