Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Access Tables

  1. #1
    Regular Coder
    Join Date
    Oct 2002
    Posts
    144
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Angry Access Tables

    In an Access table how can I calculate in a field. That is, in the retail price filed how do I calculate "cost * %?

    I feel sure that one of you guys will have the answer.

    Regards,

    The Dingbat

  • #2
    New to the CF scene
    Join Date
    Mar 2004
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It is easier to do the calc in a query. Then either use the query to display the calculated cost or input it into the table field. Using a query the calculation would look like:

    Cost:[Fieldname] * .96

    This will give you a calculated field named cost which is 96% of Fieldname.

  • #3
    New to the CF scene
    Join Date
    Mar 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    agrees

    i agree with cinci he has a point or you can do it a couple of other ways but he just told you the easiest one

  • #4
    Regular Coder
    Join Date
    Oct 2002
    Posts
    144
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Thanks guys. I was having a problem creating a form from a query so I did the calculation with a macro. It was a long way round the problem but it achieved some other solutions.

    I do appreciate your assistance though.

    With kind regards,

    The Dingbat.


  •  

    Posting Permissions

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