Access NEWBIE-Creating a Query Comparing Dates w\output of days di

[Guest]

Hi,

I am an Access newbie. Simple queries I can handle. But, I have been tasked
to create query where I compare two columns of dates and get an output of
day(s) difference between the two. This is with the intent to clean up our
data as best we can.

Any help in the matter would be greatly appreciated. I am a little lost here.

Thanks!

 

[tina]

try adding a calculated field to your query, as

DateSpan: DateDiff("d", [FirstDateField], [SecondDateField])

see the DateDiff() function topic in Access Help for details on how the
function works.

hth

 

[Guest]

Thanks Tina,

It works!

try adding a calculated field to your query, as

DateSpan: DateDiff("d", [FirstDateField], [SecondDateField])

see the DateDiff() function topic in Access Help for details on how the
function works.

hth

Hi,

I am an Access newbie. Simple queries I can handle. But, I have been tasked
to create query where I compare two columns of dates and get an output of
day(s) difference between the two. This is with the intent to clean up our
data as best we can.

Any help in the matter would be greatly appreciated. I am a little lost here.

Thanks!

 

[tina]

you're welcome

Thanks Tina,

It works!

try adding a calculated field to your query, as

DateSpan: DateDiff("d", [FirstDateField], [SecondDateField])

see the DateDiff() function topic in Access Help for details on how the
function works.

hth

Hi,

I am an Access newbie. Simple queries I can handle. But, I have been tasked
to create query where I compare two columns of dates and get an output of
day(s) difference between the two. This is with the intent to clean

up
our

data as best we can.

Any help in the matter would be greatly appreciated. I am a little

lost
here.

Thanks!