Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    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.

    Thank you!
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •