Access 2007-2019 Access 2000-2003 Access Seminars TechHelp Support Tips & Tricks Access Forum Course Index Topic Glossary Insider Circle

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Next Up: Date Time Functions in Access
By Richard Rost     8 years ago

Hey guys, just looking for some feedback. My next Access class will be Expert 27 and will continue the detailed Function Guide I started with Expert 25. This class will cover DATE AND TIME functions.

I've got a list of all of the functions, and I'll show you how to use them and what they do, but the challenge for making ALL of my classes is coming up with GOOD EXAMPLES. So, if you have anything that you'd like to see how to do in Access with regards to date and time functions, let me know.

I'm already going to show you things like how to calculate the first day of next month, how many days are in the current year, and so on... but I'm looking for lots of other examples to include in the class. So, if you've got any, post them here and I'll try to include them. Thanks!

michael
7 years ago
Thank you sire once more for time, out of your busy schedule you took time out to answer my questions. one more sir!

I have this formula DCount("*","JSS2_QUERRY","MATHS >" & [MATHS])+1
which gives me this result output for the POSITION RANK column;

MATHS           POSITION RANK
34               3
67               1
45               2
33               4

that has solved my problem,  but I want to add suffix to the ranking positions like st for first as 1st, nd for second as 2nd, rd for third as 3rd, th for fourth as 4th etc, what do I need to add to the formula above?
Thanks in anticipation!

Yeo that works, there is a couple of Tips on Project Scoring that explained this further.

For the Ordinal/Suffix Rich answered this a long time ago on the Forum.