Unanswered: Add a beginning value to total in query
I have a database that tracks driver points, but I need a beginning value to show up when I run a query.
The drivers start out with 95 points, but get points removed for offenses and points added for achievements.
My problem is when I run a query on all the drivers, only the drivers that have had some point transactions show a value. Drivers with no transactions have a blank/null field. How do I get the 95 value to populate in queries/reports?
I am using either the qryYTDPointSummaryByDriver or the qryYTDPointSummaryForAllDrivers.