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.

Thank you!