Anybody good with MS Access?

[SSG Snuggle Bunny]

I've read a ton of manuals and my head is swimming. I can't even find the words I need to nadin what I'm looking for.

I have 2 issues I need to take care of, the first playing into the second.

1) I have a DateDiff function that returns a value in years but I need to convert that value into a designated text string, i.e.

Value	String
2	Over 2
3	Over 3
4	Over 4
5	Over 4
6	Over 6
7	Over 6
8	Over 8
9	Over 8

etc


2) using the text string as returned above I need to cross-index that with the employee's pay rate code to find their monthly salary.


I don't even know what to call these functions to properly google them. If anyone could at least get me that far I'd be grateful and promise not to switch-out your Coco Puffs for a bunny surprise.

[JLO]

Does this help at all?  I realize you must have figured it out already, but here ya go anyway.

http://www.postgresql.org/docs/9.1/static/functions-datetime.html

I'm just cruising this area for a PowerPoint question.  I haven't really used office docs for awhile - so I've forgotten everything I used to know.  Good luck