Below is what my tblAdherence looks like in Access:
My query returns results like so:
Name | Adherence
Doe, Jon |
Total | 99.02
So when I run my query based off names associated to divisions it only pulls names within that division and should display there total (99.02).
Since the total is actually aligned with Total and not Doe, Jon. My result is not displaying properly, its coming up blank.
can a query associate the 99.02 with Doe, Jon or am i going to need to go a different route
My query returns results like so:
Name | Adherence
Doe, Jon |
Total | 99.02
So when I run my query based off names associated to divisions it only pulls names within that division and should display there total (99.02).
Since the total is actually aligned with Total and not Doe, Jon. My result is not displaying properly, its coming up blank.
can a query associate the 99.02 with Doe, Jon or am i going to need to go a different route
