Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: studentcp
  • Order by date
  1. studentcp

    call a public function within query Access

    I have a public function (Percentile) in the modules, when I call it in Query, Access gives me "Undefined function'Percentile' in expression". Thanks in advance.
  2. studentcp

    How to obtain Percentiles by using Query

    thanks a lot, i am going to try.
  3. studentcp

    How to obtain Percentiles by using Query

    Can I call a public function in Query?
  4. studentcp

    How to obtain Percentiles by using Query

    Since there is no percentile function I can use in Query, is that possible write a query to calculate percentiles?
  5. studentcp

    Questions about Group By

    sorry, you mean this one ArriveTime Responder_Type Incidentid 2006-01-03 7:02:22 PM BLS 416 2006-01-05 8:35:13 AM BLS 21 2006-01-07 9:45:29 AM ALS 24 2006-01-07 6:09:59 AM BLS 26 I made it by hand which the one I want.
  6. studentcp

    Questions about Group By

    Only want to group the Response.Incidentid, and return Response.Responder_Type as well. Here is the CODE:(IT DOESNOT WROK, if I group Response.Responder_Type as well, the result is not right) SELECT Min(Incident_Event.Date_Time) AS ArriveTime, Response.Incidentid, Response.Responder_Type FROM...
  7. studentcp

    Questions about Group By

    HI PHV, Thank you very much. The result doesnot look like what I want and it seems the qry never stop. The part of result from that code: ArriveTime Responder_Type Incidentid 2006-01-03 7:02:22 PM BLS 416 2006-01-03 7:17:42 PM ALS 416 2006-01-05 8:35:13 AM BLS 21 2006-01-07 9:45:29 AM ALS 24...
  8. studentcp

    Questions about Group By

    it ran, but a longer time, and the result is not right.
  9. studentcp

    Questions about Group By

    Hi Golom, I tired the code,it doesnot work. Thank you very much.
  10. studentcp

    Questions about Group By

    If I add it to my group by, the result will be: ArriveTime Responder_Type Incidentid 2006-01-23 7:36:00 AM AS 1 2006-01-23 7:37:10 AM BS 1 2006-01-03 2:25:19 PM BS 2 2006-01-03 1:16:45 PM BS 7 2006-01-03 1:17:04 PM AS 7 2006-01-03 1:14:00 PM FR 7 but the result what I want should be...
  11. studentcp

    Questions about Group By

    By using Group By, I only know how to do for two columns Such as: SELECT Min(Incident_Event.Date_Time) AS ArriveTime, Response.Incidentid FROM Response INNER JOIN Incident_Event ON Response.ResponderId = Incident_Event.ResponderId WHERE (((Incident_Event.EventEnum)=100005) AND...
  12. studentcp

    multi row to single row

    Did you mean that I need to change the format of that column? Since I got the database from a system, I cannot set the format. Sorry, I am a really new for Access. I am really apreciate your help.
  13. studentcp

    multi row to single row

    Thanks for your help,Golom You guys, have a nice day.
  14. studentcp

    multi row to single row

    It works. Thank you very much, George I got another question: I have a column with this kind of data: 2006-01-23 2:16:11 PM but I only want the date which is 2006-01-23. How could I do it? Thanks again for your help.
  15. studentcp

    multi row to single row

    Hi every one, I am a Access beginer, I have some questions to ask. Here is my question: I want to compare the id first, if the ids are the same pick the row with the earliest time, if id is unique then store. For example: id Arrive Time 417 2006-01-06 7:50:56 PM 417 2006-01-06 8:15:17 PM 64...

Part and Inventory Search

Back
Top