Results 1 to 2 of 2
  1. #1
    xoxoAllyCat is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2013
    Posts
    1

    Can someone help me? =)

    I am trying to complete this but I can only get up to 1 query and then everything erases.....
    I never used Access before....thank you




    Product
    Name
    Product
    Number

    Taxable
    Amount
    Purchased
    Purchase
    Price
    Amount


    Sold
    Selling
    Price

    Revenue

    Expense

    Profit
    Sales
    Tax
    Pizza XA-124-Q No 128 $5.25 92 $10.50
    Potato Chips TN-258-Z No 1,024 $1.79 833 $3.58
    Soda PG-909-B Yes 512 $2.78 476 $5.56
    Ice Cream KR-762-A No 256 $1.99 239 $3.98





    Create the following select queries:

    1. A listing of the Products in Name order with their Selling Price.
    2. A listing of Product Numbers that are not Taxable.
    3. A listing of the Products where the Amount Purchased is not greater than 500.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    Is that the only table you are working with? If so, this is not a normalized database. If not, we need to know tables in the db.

    What do you mean by 'everything erases' - the query does not return any records?

    Show the SQL statements of attempted queries.

    Are you using the query builder?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

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