MS Access Help needed

[JAM]

Can anyone please help me on how to calculate the difference between two dates in Access in years and months.

I tried to Google it, but in vain.

Please help.

[rustypup]

your google is broken

[Kronos]

I've explained this before, but i'll do it again in case you haven't read my reply last time:

1: Backup your data
2: Delete MS Access
3: Install MS SQL Server 2005
4: import your data.
5: all access related problems solved!

[Tribble]

your google is broken

What he said.

[Kronos]

your google is broken

What he said.

My solution is still better

[Tribble]

your google is broken

What he said.

My solution is still better

Nope - just converted one of my access databases to a SQL backend - and now having to learn SQL. Not as easy as I was led to believe. I am only using SQL Manager at the moment - so would hate to think what I will have to go through when I want to design reports and queries

[Kronos]

Nope - just converted one of my access databases to a SQL backend - and now having to learn SQL. Not as easy as I was led to believe. I am only using SQL Manager at the moment - so would hate to think what I will have to go through when I want to design reports and queries

That doesn't make Access better.

When you have learnt how to use queries and stored procs, and how Reporting works it will be so much more powerful that you won't believe how you could ever have been satisfied with Access.

[Tribble]

That doesn't make Access better.

When you have learnt how to use queries and stored procs, and how Reporting works it will be so much more powerful that you won't believe how you could ever have been satisfied with Access.

Ah so it is one of those "wait and maybe you will see" thingys? It has to be better now - or what motivation to I have to learn it? I am still learning VBA and adding SQL makes it rather daunting.

[rustypup]

if all this DB is doing is logging, installing SQL2005+BI+et al is very much like installing a cruise missile in place of a cracker...

[Tribble]

Yep JAM, - puppy has piqued my interest. What does your database do?

[JAM]

Sorry for taking so long to respond. It is a Human Resources Data Base. I want to create a Form that calculates experience in years and months once you have entered the date of appointment.

[rustypup]

HR

the best approach is

Code: Select all

DROP DATABASE; --

[Tribble]

Most of the ones I write are for insurance companies or banks. An HR one could be interesting. But must learn SQL first.

[Screeper]

Tribs - learning SQL skillz is never a bad thing. It isn't as tricky as you first think (although if you want it to be, SQL can be insanely complex). But is certainly is one of those 'wait and see' things where once you get over the initial first hurdles then you'll see the light

lol @ rusty

[Tribble]

Screeper, I will try and believe you seeing I have no choice - I have to learn it.

[rustypup]

once you get over the initial first hurdles

one of those 'hurdles' being the query response "1,341,622 rows affected"