User Profile

Collapse

Profile Sidebar

Collapse
Danyluk
Danyluk
Last Activity: Sep 2 '10, 03:50 AM
Joined: Aug 10 '10
Location: California
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Danyluk
    replied to Aggregate Query
    in Access
    Well it seems like I am getting there. This is what I have now:

    Code:
    TRANSFORM Count(callhist.userid) AS total
SELECT callhist.userid, callhist.username, callhist.resultcode
FROM callhist
WHERE (((callhist.calldt)>=[Enter Start date] And (callhist.calldt)<=[Enter End Date]))
GROUP BY callhist.userid, callhist.username, callhist.resultcode
PIVOT callhist.resultcode;
    ...
    See more | Go to post

      Leave a comment:

    • Danyluk
      replied to Aggregate Query
      in Access
      colintis,
      I tried what you said and it gives the same result as the one that I did.

      Do you have any other suggestions?
      See more | Go to post

        Leave a comment:

      • Danyluk
        started a topic Aggregate Query
        in Access

        Aggregate Query

        I have certain tables as follows:

        UserID UserName CallDT ResultCode

        I am trying to run a query that will show me the total amount of calls for "UserID"

        This is what I have done.

        Code:
        SELECT     UserID, Sum(CAST(UserID as Int))AS 'Total',  UserName, CallDT, ResultCode
FROM         CallHist
WHERE     (CallDT BETWEEN '2010-08-17' AND '2010-08-18') AND (NOT (UserID = N'PDIALER'))
        ...
        See more | Go to post
        • Danyluk
          replied to I need help with an IF statement
          in Access
          @dsatino

          I want to just say thank you very much for all your help on this. I have really one more question in regards to grouping all of this together in a sort of summary.

          Should I do this sum? in a query or on the report in access?

          Basically what I am trying to accomplish is this.

          I want to see the following columns in an Access Report

          UserID Queue5 Queue0 Queue1 AnsweringMach...
          See more | Go to post

            Leave a comment:

          • Danyluk
            replied to I need help with an IF statement
            in Access
            @dsatino

            I am not sure with the VBA but I would like to learn :) how would I union if I got stuck.

            Also, is the Union going to make things perform extremely slow? Would the VBA perform faster?
            See more | Go to post
            Last edited by Danyluk; Aug 10 '10, 10:24 PM. Reason: Added information

              Leave a comment:

            • Danyluk
              replied to I need help with an IF statement
              in Access
              @dsatino

              So I think it might be a problem with the amount of result codes. I am getting an error saying it is too complex.

              This is what I have now.

              SELECT CallHist.Result Code,Switch([callhist.result code]=5,"Cancel After Card Declined",[callhist.result code]=6,"Card Declined Sent Admin",[callhist.result code]=7,"Spanish Speaker",[callhist.result code]=30,"Answering Machine",[callhist.result code]=31,"Abandoned...
              See more | Go to post

                Leave a comment:

              • Danyluk
                replied to I need help with an IF statement
                in Access
                @dsatino

                You ROCK!!! It worked. Just what I was looking for. Thank you.
                See more | Go to post

                  Leave a comment:

                • Danyluk
                  replied to I need help with an IF statement
                  in Access
                  @ dsatino
                  Thank you everyone for the help this is what I have

                  SELECT CallHist.Result Code, Count(CallHist. ResultCode) AS CountOfResultCo de, CallHist.UserID , CallHist.QueueN o, Count(CallHist. QueueNo) AS CountOfQueueNo
                  FROM CallHist
                  WHERE (((CallHist.Cal lDT)>=[Enter Start date] And (CallHist.CallD T)<=[Enter End Date]))
                  GROUP BY CallHist.Result Code, CallHist.UserID , CallHist.QueueN o
                  ORDER BY CallHist.Result Code;...
                  See more | Go to post

                    Leave a comment:

                  • Danyluk
                    started a topic I need help with an IF statement
                    in Access

                    I need help with an IF statement

                    I currently have a column in a query that is called result codes. These result codes are either 45,80,30 etc.. What I am trying to do is since I have the query that runs I built a report and it show the result code fine but I want to have it covert the result code to text that I specify.

                    Example if result code = 30 I want it to say "Not Interested" instead of showing 30

                    Can someone guide me in the right direction?...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...