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!
-
Congratulations derfloh 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
- Content: Threads
- Order by date
-
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.- studentcp
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
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? -
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... -
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...
