I hope someone can help, I've been working on this problem but can't get it to work. I have a report based on a query that counts what type of equipment a location has received based on a parameter. The report opens and asked for the date you want to view, a date signaling the beginning of a week, and a date signaling the end of the week. Then the report displays the equipment type, how many were shipped over the week, and how many have been shipped since the date entered. So you get something like this for each location.
Location
Description ShipLastWk ShipYTD
Laptop type A 0 100
Laptop type B 5 60
Workstation A 120 2700
My boss now wants to see the the total number of units shipped by equipment type for the last week and YTD. I tried using DSum on the underlying query, but I keep getting an error. Here is my DSum to attempt to retreive shipping for Laptop type A for the past week.
=DSum"[SHIP_LAST_WK]","BUDGET_VS_ACTUAL_SHIP","[Description]='Laptop type A'"
Any help would be greatly appreciated
Location
Description ShipLastWk ShipYTD
Laptop type A 0 100
Laptop type B 5 60
Workstation A 120 2700
My boss now wants to see the the total number of units shipped by equipment type for the last week and YTD. I tried using DSum on the underlying query, but I keep getting an error. Here is my DSum to attempt to retreive shipping for Laptop type A for the past week.
=DSum"[SHIP_LAST_WK]","BUDGET_VS_ACTUAL_SHIP","[Description]='Laptop type A'"
Any help would be greatly appreciated
