Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Location
    Texas
    Posts
    1

    simple expression!

    I would like to calculate the tax on a product. widget sells for 10.00, the tax is .0825. I can't seem to get it right.

    Would someone point me in the right direction.

    Thanks


    Lon

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    I'm not a fan of storing a calculated field in a table but you want to query

    TotalPrice: priceFieldName * 1.0825

    Thats what you would enter under the Field: section in the query design view.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. need help, expression is too complex?
    By ice673 in forum Queries
    Replies: 5
    Last Post: 02-15-2010, 09:03 PM
  2. Simple Expression
    By Bridgid in forum Queries
    Replies: 7
    Last Post: 06-17-2009, 09:07 PM
  3. What's wrong with this expression
    By tallroger in forum Access
    Replies: 1
    Last Post: 05-05-2009, 04:00 PM
  4. Help With an expression
    By kylem4711 in forum Queries
    Replies: 2
    Last Post: 04-23-2009, 01:57 PM
  5. Expression Builder
    By mistaken_myst in forum Access
    Replies: 2
    Last Post: 05-07-2008, 01:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums