Results 1 to 2 of 2

Thread: math

  1. #1

    Thread Starter
    Hyperactive Member badgers's Avatar
    Join Date
    Sep 1999
    Location
    Madison, WI USA
    Posts
    444
    can I do math in an Access Database??
    I would like to say that a particular field is the sum of the same field in the previous 10 records.
    is this possible?
    thank you for your time and have a good day
    I am so skeptical, I can hardly believe it!
    PS I am not a 'hyperactive member' I am a cool, calm, and collected member

  2. #2
    Lively Member
    Join Date
    Jan 1999
    Location
    Rochester NY, USA
    Posts
    93
    Uhm.. you can't do math "in" a database.. but you can get the two values, add them together and store the result in another field. If it's just going to be displayed, you might be better off just caluclating this on the fly.

Posting Permissions

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



Click Here to Expand Forum to Full Width