Alpha Video Training
Results 1 to 5 of 5

Thread: Alpha 4 Ver. 6------HELP

  1. #1
    Charles Slack
    Guest

    Default Alpha 4 Ver. 6------HELP

    I am entering a very large personal library into Alpha 4 V6.
    One of the fields is for each book price. I want another field for a running total for all the book prices I have entered. Will someone please come to my rescue??

  2. #2
    "Certified" Alphaholic
    Real Name
    Ken Herrold
    Join Date
    May 2000
    Posts
    1,081

    Default RE: Alpha 4 Ver. 6------HELP

    Charles:

    If you're viewing these records in a Browse and would like an incrementing 'running total' field, I don't know how to do that.

    What you could do, is to add another field holding a calculated field rule using DBSUM function. Each record then would have as its last field a total of everything in the db. When you deleted and and packed a record, it's amount would be subtracted from the total.

    There may be others on the site who can help with the 'running balance' you might prefer.

    Ken

  3. #3
    Charles Slack
    Guest

    Default RE: Alpha 4 Ver. 6------HELP

    Thanks Ken for your reply, I will try it. If I need further help will you be available?
    Charles

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: Alpha 4 Ver. 6------HELP

    Charles,

    You may find that it makes more sense *not* to include a permanent running total field in each record.

    Consider what happens with the first two books.

    When the first book is entered its cost and the running total are the same.

    When the second book is entered its cost and the previous sum of book costs would presumably be totalled.

    If you go back to the first book the running total is wrong. It no longer contains the running total of all books in the table.

    If you add a third book, and then delete the second, the first and third records are both wrong. Neither contains the actual running total of the books in the table.

    About the best such a field might indicate is the 'snap shot' running total at the time the record was entered. It's likely to prove useless for any other purpose and almost surely will rarely equal the actual running total of all records in the table.

    My suggestion would be to leave it out of the table altogether. Just record the cost associated with each record, and create a calculated field for the running totals in your reports.

    -- tom

  5. #5
    "Certified" Alphaholic
    Real Name
    Ken Herrold
    Join Date
    May 2000
    Posts
    1,081

    Default RE: Alpha 4 Ver. 6------HELP

    Tom's right!

    Here's what I did for a checking account balance. I have a set with a header - one link field and another for 'balance'. The form for the set takes data in another db Region browse. The field rules for the region 'book price' in your case would be a post to that header balance field - external/Add/unpost on delete.

    To adjust for the removal of a book [and its price] either delete the record or change the price amount to zero. That would remove its value from the total.

    Conversely when a new book record is added the total will increase by that price amount.

    If you create a form - header and browse[items]you can display the 'balance field' on the form and watch it update on data entry/change.

Similar Threads

  1. Converting database files from Alpha 4 to Alpha 5
    By Jasmine in forum Upgrading to Alpha Five from Alpha Four
    Replies: 8
    Last Post: 01-10-2007, 01:51 AM
  2. Alpha 4 data files working in Alpha 5.
    By james thompson in forum Alpha Four Versions 7 and 8
    Replies: 9
    Last Post: 04-07-2004, 06:31 AM
  3. Alpha Tech Support - Problem upgrading Alpha 5v.4
    By Bill Hahn in forum Alpha Five Version 4
    Replies: 1
    Last Post: 06-24-2002, 07:35 AM
  4. alpha 4 added to alpha 5, makes me use the disc
    By Kim Sargent in forum Alpha Five Version 4
    Replies: 1
    Last Post: 08-29-2001, 09:44 AM
  5. Alpha 4 to Alpha 5 Seminar Announced!
    By Susan Bush in forum Announcements
    Replies: 5
    Last Post: 08-24-2001, 09:26 AM

Bookmarks

Posting Permissions

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