I used report for running sum. But right now I need running sum by tool number in query to create a graph. I have been trying for days. Tool number is text, shiftend is date, and output is number. Please help I need to have this demo out by next week.
I have created my own table (image1), and tested the SQL against it (see sql below) and included results (image3)
As you can see, the output is a running sum, grouped by tool. Unfortunately I don't have
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database. This article shows how to recreate this functionality in Windows 7 through 10.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…