I
InventoryQueryGuy
I need to get records that are up to three months old from today (from
DateModified), then group together all those tools with the same designation
(from ToolDesignation), then sum the quantities of each tool signed out by
its designation (from SignOutQuantity).
After this I will be performing further calculations but perhaps someone can
give me a hand to write a statement so that I can at least get started!
Cheers.
DateModified), then group together all those tools with the same designation
(from ToolDesignation), then sum the quantities of each tool signed out by
its designation (from SignOutQuantity).
After this I will be performing further calculations but perhaps someone can
give me a hand to write a statement so that I can at least get started!
Cheers.