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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Rank function in access
yes, this is finally working., thank you sooo much :))- shicmic
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Rank function in access
This is the code: ime is name , MSISDN is customers phone number and pDatum means date of the order. and the error i get is : you tried to execute a query that does not include the specified expression 'dupe.pDatum'as part of an aggregate function. SELECT q.Ime, q.MSISDN, q.pDatum, (SELECT...- shicmic
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Rank function in access
hi all, i have been trying to use this code so to rank Agents in table. I want to rank them as they offered product to the same user, but the agent who offered first will have rank 1, and the other is rank 2. SELECT A.ID, A.Type, A.CDate, Count(*) AS Rank FROM yourTable AS A INNER JOIN...- shicmic
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
