Results 1 to 3 of 3

Thread: Table Equation

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table Equation

    OK...so I am a dummy....my table has 1)AmtDue, 2)AmtPaid and 3)Balance. I know in a form you can make the calculation--AmtDue-AmtPaid....but can this be done in the table itself?

    I tried putting AmtDue-AmtPaid in the "default" of the Balance field, but it bombed.

    Thanks,
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Equation

    Roberta:

    I don't know of a way to build an equation like that into the construct of a table, nor am I sure you'd really want to. You can use an update query to set the balance field = to [AmtDue]-[AmtPaid], but for my money, I'd calculate that bit of information on the fly in your queries, forms and reports. <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Equation

    You're right Roberta, it's not the way to do it <img src=/S/frown.gif border=0 alt=frown width=15 height=15> But I must ask, how are you updating the AmtPaid field in the table ? I assume if there is an outstanding balance, you would expect more than one payment, correct ? If you already have a means of increasing the amount paid (through a form perhaps?), you should use the same method to adjust the Balance field. But I wouldn't recommend you continue down this path <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

Posting Permissions

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