Decade - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Decade

Scott Axton

4 years ago

Richard
Since you are working down the Date functions in the FastTips I thought I would share the following.

I recently had a need to figure out Decades in which a date fell. This is what I came up with.

Just seeing if you had an idea for a better method and or share it if someone else ever had the need.
If you deem it worthy feel free to steal it for the Code Vault and or share it as a video.

	Scott Axton OP @Reply 4 years ago

	Adam Schwanz @Reply 4 years ago
Nice, could do the same thing with century and millenia :P.

	Scott Axton OP @Reply 4 years ago
A little more background. I was asked to break out a count of member ages. to get some demographics for advertising. The easiest way i could figure was to break it out in decades. Then aggregate the age by decade. It worked for what I needed.

	Richard Rost @Reply 4 years ago
I got a similar question a while back. I'll add it to the list.

	Richard Rost @Reply 4 years ago
This will be tomorrow's Fast Tip video. Decades

	Scott Axton OP @Reply 4 years ago
Decades FastTip was pretty darn cool! Thanks for the shout out. I really liked the different way of doing it. It seems slightly less complicated. Is there an advantage of doing it one way or the other?

	Richard Rost @Reply 4 years ago
Not that I can think of. It's just math. :)

	Adam Schwanz @Reply 4 years ago
What about just Decade: Year(dob)\10 & '0s'

	Adam Schwanz @Reply 4 years ago
I cant think of a simpler way. I originally thought to use left but thats just more formula lol

	Adam Schwanz @Reply 4 years ago
Also those should be double quotes, my phone apparently wont let me do them and changes to single lol

	Richard Rost @Reply 4 years ago
Sure. If your end result is JUST the string, then that'll work. I was trying to give people the numeric decade starter first for like maths and stuff.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View