vendredi 5 janvier 2018

Access Query - how to randomly select records

I have this query that creates a list of 10 names that are in my facebookfriends list that are not already in my contact list, but I want it to randomly select these 10 names.

I can't get the other examples to work with my query, please can you help me get this right.

Here is the sql:

SELECT TOP 10 FaceBookFriends.FaceBookName, FaceBookFriends.FullName, FaceBookFriends.FirstName, FaceBookFriends.Surname, FaceBookFriends.DateAdded FROM FaceBookFriends LEFT JOIN Contact_List ON FaceBookFriends.[FullName] = Contact_List.[Full _Name] WHERE (((Contact_List.[Full _Name]) Is Null));

I added a "ORDER BY Rnd(FaceBookFriends.FullName)" at the end of the report but it doesn't work

thanks




Aucun commentaire:

Enregistrer un commentaire