The Conservative Cave

The Help Desk => Computer Related Discussions & Questions => Topic started by: SSG Snuggle Bunny on April 03, 2013, 11:30:21 AM

Title: Anybody good with MS Access?
Post by: SSG Snuggle Bunny on April 03, 2013, 11:30:21 AM
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.


ValueString
2Over 2
3Over 3
4Over 4
5Over 4
6Over 6
7Over 6
8Over 8
9Over 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.
Title: Re: Anybody good with MS Access?
Post by: JLO on April 21, 2013, 09:31:36 PM
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  :cheersmate: