Hi, I'm trying to create a calculation of a raw material bought on a purchase that gives a result from two of the purchase dates.( a start date and end date)
I am using this sql query in a field to get the result but I'm getting a ?
ExecuteSQL ( " SELECT AVG(Pounds) FROM Inventory
WHERE Purchase Date BETWEEN ? AND ? "
; "" ; "";
I have created a relationship for pdatestart and pdateend to the Purchase Date also.
Any Ideas where I'm going wrong?