hi, i had a couple of problems with my homework this evening. it's some SQL/ Access. i had gone through and created my neccessary tables, and entered all the data, and i flippe dthe page and i have to do some querys. i have two tables ITEM(ItemNo, ItemName, ItemPrice, QtyOnHand) and the INVITEM(InvNo, ItemNo. Qty)
so i usually am used to the SQL at school, but i am home fro the weekend and all i have here is MS access. but i only have 3 questions left that i need help with
please if some one could help me out jus a bit with these last couple it'd be great. but i think i have to do them with access, and i know they have a sql design. and help would b great... thanks - justin
....that's what i got in access, and im pretty sure that's not really what i am trying to get at. access si alot more differnt than i thought..? i gives me the wrong quanitity. like i have invoice number 1001, and i has 3 diff items on it, that total 19 pieces. but some how i only get 3. b/c i must add up each oreder not each piece. please help.
so i usually am used to the SQL at school, but i am home fro the weekend and all i have here is MS access. but i only have 3 questions left that i need help with
Code:
6- Display the INVNO and number of items ordered in each invoice.
11- display INVNO and the total price for each invoice.
13- display ItemName and ItemPrice for all items cheaper than a Nut.
please if some one could help me out jus a bit with these last couple it'd be great. but i think i have to do them with access, and i know they have a sql design. and help would b great... thanks - justin
Code:
6- Display the INVNO and number of items ordered in each invoice.
SELECT INVITEM.InvNo, Count(INVITEM.Qty) AS CountOfQty
FROM INVITEM INNER JOIN ITEM ON INVITEM.ItemNo=ITEM.ItemNo
GROUP BY INVITEM.InvNo;