Author Topic: Anybody good with MS Access?  (Read 2022 times)

0 Members and 1 Guest are viewing this topic.

Offline SSG Snuggle Bunny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 23048
  • Reputation: +2232/-269
  • Voted Rookie-of-the-Year, 3 years running
Anybody good with MS Access?
« 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.
According to the Bible, "know" means "yes."

Offline JLO

  • Hero Member
  • *****
  • Posts: 1060
  • Reputation: +55/-17
Re: Anybody good with MS Access?
« Reply #1 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:
Giving money and power to Democrats is like giving whiskey and car keys to teenage boys--