Solved Access query help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

nursell

Thread Starter
Joined
Jul 26, 2011
Messages
143
Hi Guys,

I am trying to create a query that calculates the number of day between 2 dates.

Colum 1: RMANUMBER
Colum 2: ENTERED
Colum 3: PROCDATE
Colum 4: NumberOfDays

Date 1 is "ENTERED" and date 2 is "PROCDATE" and i would like the number of days between to be in "NumberOfDays"

Can anyone help please?

Many thanks.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Hello Nursell, long time no speak.
Is managed's response OK for you?
 

nursell

Thread Starter
Joined
Jul 26, 2011
Messages
143
Hi OBP,

Yes long time no speak.

Yes i have it working, i used the following expresion

Days: DateDiff("d",[ENTERED],[PROCDATE])

Thanks for you help.
 

managed

Allan
Moderator
Joined
May 24, 2003
Messages
15,067
Glad you got it working.

Please click the Mark Solved button at the top of your page.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top