Reference to Date Field on Form Not Recognized

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!!
 
F

fofa

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
 
F

fofa

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does abs work for negative values? 2
abs function not adding up - turning negative to positive 7
Count versus Sum 2
Is field between date range on form 2
Abs function causing +- errors when summed 5
Make Table But With No Common Joins 1
Problem with Date Restrictor on Form 3
Date query parameters entered from form not working 1

Top