Reference to Date Field on Form Not Recognized

  • Thread starter Thread starter mj
  • Start date Start date
M

mj

Hi. I have a query formula that sums sales for the prior
year to date time period by summing invoices that fall
between two dates which are referenced on a form:

PYTDDollarShipments: Sum(Abs(([InvoiceDate] Between Forms!
Dashboard!FirstDayOfYearLastYear And Forms!Dashboard!
LBDLastYear))*[DollarsShipped])

The dates aren't being referenced. Any thoughts on how to
code this so that they're recognized? Thanks!!
 
PYTDDollarShipments: Sum(Abs([DollarsShipped]))

Then put the date range in the criteria for the query unde
InvoiceDate. But I don't understand what the Date * Dollars Shipped i
all about, or why you are using ABS function
 
PYTDDollarShipments: Sum(Abs([DollarsShipped]))

Then put the date range in the criteria for the query unde
InvoiceDate. But I don't understand what the Date * Dollars Shipped i
all about, or why you are using ABS function
 
Back
Top