Results 1 to 2 of 2
  1. 02-16-2011, 11:33 AM #1
    ampd
    ampd is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    1

    Creating a Query Need HELP


    I need to find out how to write the formula in Access for a problem I am currently working:

    Calculating revenue by multiplying the discounted price by the quantity sold.
    Reply With Quote Reply With Quote
  2. 02-16-2011, 12:12 PM #2
    alansidman's Avatar
    alansidman
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In a query that has your two fields, in a new field (column) type this:

    Revenue: [QuantityField]*[DiscountedPriceField]

    Run your query. Change the field names above to represent your field names.

    Alan
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. creating a query? need help badly
    By MrT1993 in forum Queries
    Replies: 1
    Last Post: 02-16-2011, 10:24 AM
  2. Creating SQL query with one-to-many field
    By slaterino in forum Queries
    Replies: 2
    Last Post: 09-08-2010, 07:56 AM
  3. Creating a Grouping query
    By Dev in forum Access
    Replies: 4
    Last Post: 09-02-2010, 06:46 AM
  4. Creating input box for query
    By dcecil in forum Queries
    Replies: 1
    Last Post: 06-23-2009, 10:08 AM
  5. Creating INT function within a Query
    By LCorrieri in forum Queries
    Replies: 3
    Last Post: 01-25-2008, 10:38 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums