Results 1 to 2 of 2
  1. #1
    josh21 is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    6

    cost comparison queries

    The question is asking:


    This query should provide a cost comparison of the items returned by the query above. You will use the query above as a starting point for this query. The query should return the following fields: ItemID, ItemDescription, SupplierID, SupplierName, and ItemCost.

    I don't get what I'm supposed to do next. Am I even starting off correctly?

    Click image for larger version. 

Name:	Capture.PNG 
Views:	11 
Size:	4.3 KB 
ID:	18923

    Click image for larger version. 

Name:	2.JPG 
Views:	4 
Size:	151.2 KB 
ID:	18929
    Last edited by josh21; 12-02-2014 at 05:20 PM. Reason: added

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Josh,

    Readers only know what you show or tell them. Can you tell readers what you are trying to do in plain English? Once they understand
    what you are trying to do, you can show some tables and fields and perhaps some sample data records to pinpoint the problem. Once
    readers have a clear understanding of your problem, they will offer more focused responses.

    Instead of saying it does give what you want, give them some data, show then the result you got compared to the result you want/need.
    Good luck

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

Similar Threads

  1. Resources Cost
    By salim in forum Database Design
    Replies: 2
    Last Post: 01-25-2014, 02:59 AM
  2. Construction Cost Estimating
    By minimal in forum Database Design
    Replies: 1
    Last Post: 08-24-2012, 02:15 PM
  3. Most recent cost query
    By nigelbloomy in forum Queries
    Replies: 9
    Last Post: 07-12-2012, 02:41 PM
  4. Service to Cost by Quarter HELP!!!
    By campanellisj in forum Database Design
    Replies: 5
    Last Post: 09-26-2010, 06:58 AM
  5. Cost of a database
    By P5C768 in forum Access
    Replies: 1
    Last Post: 04-22-2010, 04:53 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