Consulting

Results 1 to 1 of 1

Thread: Test Code Tags on Access Code

  1. #1
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location

    Test Code Tags on Access Code

    Select Query
    SELECT Orders.KidsID, [Fname] & " " & [Lname] AS Name,  _
    CampKids.CampID, _
    Cabins.Cabin, _
    CampKids.Balance,_
     IIf(([ItemID]=5 Or  [ItemID]=58) And Not [Received],1) AS TShirt, _
    IIf(([ItemID]=12 Or  [ItemID]=53) And Not [Received],1) AS DVD, _
     IIf(([ItemID]=17 Or  [ItemID]=54) And Not [Received],1) AS Journal, _
    Orders.Received FROM Cabins RIGHT _
    JOIN (Orders INNER JOIN CampKids _
    ON Orders.KidsID = CampKids.KidsID) _
    ON Cabins.CbnID = CampKids.CabinID
    WHERE (((CampKids.CampID)=GetCmp()) AND ((Orders.Received)=False));
    Aggregate Query
    SELECT [HasBalance-Select].KidsID, _
    First([HasBalance-Select].Name) AS  FirstOfName,_
    First([HasBalance-Select].Cabin) AS FirstOfCabin,  _
    First([HasBalance-Select].Balance) AS FirstOfBalance, _
    Sum([HasBalance-Select].TShirt) AS SumOfTShirt,  _
    Sum([HasBalance-Select].DVD) AS SumOfDVD,  _
    Sum([HasBalance-Select].Journal) AS SumOfJournal
    FROM [HasBalance-Select]
    GROUP BY [HasBalance-Select].KidsID;
    Last edited by SamT; 09-07-2014 at 09:32 AM.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •