Results 1 to 2 of 2
  1. #1
    Mschneider331 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    6

    Calculated Quieres


    I need some help understanding what I need to do I'm stuck currently trying to figure it out.

    My instructions are:
    Build a query that will display the invoice number, description and a calculated field named Extended Price that will show the total price (the retail price and any applicable discounts) of each item invoiced that has a discount percent.

    I know this is impossible without the file. System keeps failing download I will try again.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Where are you stuck? Are you having trouble creating a calculated field? What happens if you try one of the built in tools displayed within the Ribbon of the Query Designer? Does the term, 'Alias', mean anything to you?

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

Similar Threads

  1. Replies: 2
    Last Post: 12-30-2014, 01:32 PM
  2. Calculated Field
    By rosscortb in forum Access
    Replies: 5
    Last Post: 11-24-2014, 01:38 PM
  3. Replies: 12
    Last Post: 10-01-2013, 12:59 PM
  4. Calculated Sum in Form
    By TimC in forum Forms
    Replies: 6
    Last Post: 10-25-2012, 05:37 AM
  5. Exporting Quieres - Filenames
    By jquickuk in forum Programming
    Replies: 1
    Last Post: 05-02-2009, 06:51 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