Search results

theDBguy- thank you, I was just about to upload a sample and then saw The_Doc_Man's response. The_Doc_Man-you've solved it for me. All the data is stored in a SharePoint list and the Syndicate Number field was a Choice (1-6). I changed it to number and it of course works as it should. I also...

Hello all, I'm currently producing a database to store details about candidates going through a selection process. Once all of the data has been entered into the db, I would like to run a query that shows a rank for each candidate based on their overall score in both their syndicate and the...