Search results

  1. C

    Frustrated beyond belief with Time conversion

    I have been playing with trying to convert 'seconds' ( a six digit number) into hours;minutes;seconds. I finally came up with the following code that will return the hh:mm:ss in the immediate window, but not in the application itself. It keeps sticking on 'MyHours = bigseconds \ 3600' What am I...
  2. C

    call a function in a form to reflect in a report.

    why would a variable prevent the function from processing?
  3. C

    call a function in a form to reflect in a report.

    Hi guys(and gals) Silly question. I have a function that I am trying to call to a report. The research material on this is very basic and very sketchy. Is there a standardized way to call a function from a control in a form to reflect those actions being performed in the report? CoachPhil
  4. C

    summarizing multiple recordsets

    How about sorting for individual employees?
  5. C

    summarizing multiple recordsets

    Sorry, forgot to mention that this report is based on a query that has all the available information
  6. C

    summarizing multiple recordsets

    I have 100 + employees and would like to accumulate their talk times on the telephone over a period of time. Some of the items that would be accumulated are; t_logged_in talk_time n_ready_time these items are all reported in seconds, which I will need to convert to hh:mm:ss Other items would be...
  7. C

    summarizing multiple recordsets

    Showing my newbiness with this question, If I have a table with 100 employees and a record of their activity for each day of the month, can I total their records and show the summed total in 1 text box on the report? CoachPhil
  8. C

    Manipulate Time in a Report

    Gang, Is it possible to take a populated number in a Report and convert it from seconds to hours and minutes? CoachPhil
  9. C

    all records from one employee

    Thanks Paul, I'll give that a try. CoachPhil
  10. C

    all records from one employee

    Gang, I have a report based on a query where I would like to pull one employee from the query, then all recordsets associated with that employee. I have been at this for a while and am missing the obvious, any help would be appreciated. CoachPhil
  11. C

    SQL Statement

    I had updated the database to include a new column 'AgentName' and ran the query; SELECT CLAvgQuery.[Certified Listeners Name] AS Expr1, CLAvgQuery.[AvgOfDid the CL give Feedback in a Timely Manner1] AS Expr2, FeedbackSessionTotalsQuery.[Avg Of Did the CL give Feedback in a Timely Manner] AS...
  12. C

    SQL Statement

    Has anyone come across a 'destination field' error in a query? CoachPhil
  13. C

    SELECT DISTINCT Query

    Thanks again George
  14. C

    SELECT DISTINCT Query

    Sql Select Bob, Sorry for the ommission, I was trying to simplify the question. The fields accept the answers from a questionnaire, there are six questions, where the person who completes the form rates the user on a scale of 1 to 5, then can offer additional comments on the rating. 1 table...
  15. C

    SELECT DISTINCT Query

    I will try to adjust as many names as possible, good suggestion, thank you CoachPhil
  16. C

    SELECT DISTINCT Query

    Sql Bob, I am trying to populate the following report, thus the ungainly names, for ease of use, believe it or not. I will try
  17. C

    SELECT DISTINCT Query

    Select Distinct Thanks for the assist Bob, when I change it to this; "SELECT DISTINCT FeedbackSession.[Certified Listeners Name] FROM FeedbackSession WHERE FeedbackSession.[Did the CL give Feedback in a Timely Manner] LIKEFeedbackSession. [Certified Listeners Name]" it still returns...
  18. C

    SELECT DISTINCT Query

    Hello all I have a DB with 1-table = FeedbackSession 2 columns- 'Certified Listeners Name' and 'Did the CL give Feedback in a Timely Manner' I have five individuals listed in this table as Certified Listeners, I am trying to determine their average score from a second column. I cannot get...
  19. C

    SQL in Access

    George, Thank you, it worked fine that way, just playing with the size of the report now (7 pages). Sometimes we make things more difficult than they actually are. thanks again, Coach
  20. C

    SQL in Access

    Thank you George, The name of the table is indeed 'FeedbackSession' not the DB. I will check the spelling on the Certified Listener and yes, I would like to display this information on a Report. When I say no go, I mean that I can produce no results, it won't select any of the \Certified...
Back
Top Bottom