Needs Help with Creating SQL Statement

Dim intSearchMonth, intSearchYear, intItemID

intSearchMonth = month to search
intSearchYear = year to search for
intItemID = ID for the item your searching

' SQL for items for a certain month
strSQL = "SELECT Count(ItemID) AS Ordered FROM tblOrders WHERE Month(tblOrders.Order_Date) = " & intSearchMonth & " AND tblOrders.ItemID = " & intItemID & " "


' SQL for items for a certain Year
strSQL = "SELECT Count(ItemID) AS Ordered FROM tblOrders WHERE Year(tblOrders.Order_Date) = " & intSearchYear & " AND tblOrders.ItemID = " & intItemID & " "


the above is on the idea you have a orders table holding the Item ID that was ordered. without more details we can't get it exact. hope the above help

good point cheers for that.. heres a re write below


Dim intSearchMonth, intSearchYear, intItemID

intSearchMonth = month to search
intSearchYear = year to search for
intItemID = ID for the item your searching

' SQL for items for a certain month
strSQL = "SELECT Count(ItemID) AS Ordered FROM tblOrders WHERE Month(tblOrders.Order_Date) = " & intSearchMonth & " AND tblOrders.ItemID = " & intItemID & " AND Year(tblOrders.Order_Date) = " & intSearchYear & " "


' SQL for items for a certain Year
strSQL = "SELECT Count(ItemID) AS Ordered FROM tblOrders WHERE Year(tblOrders.Order_Date) = " & intSearchYear & " AND tblOrders.ItemID = " & intItemID & " "

Hi Misty!

i'm not sure if you still need answer to your last query but just the same, here is my suggestion:

if you want to know all the customers that have web hosting record, try this:

select C.*
from CUSTOMERS as C
inner join WEBHOSTING as WH on C.webhostingid = WH.webhostingid

if you want to know all the customers that have no web hosting record, try this:

select C.*
from CUSTOMERS as C
left outer join WEBHOSTING as WH on C.webhostingid = WH.webhostingid
where WH.webhostingid is null

Hope this helps