Link to home
Start Free TrialLog in
Avatar of NO_CARRIER
NO_CARRIER

asked on

SQL - count difference in dates?

I have two fields in a table:
i.e. DATE_1 and DATE_2

I want to count the total records that have a difference in dates.  (i.e. how many records have a difference of 1 day in the date, the total records for 2 days, all the way up to 14 days.)

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NO_CARRIER
NO_CARRIER

ASKER

hi angelll... it's giving some errors on the first line for me.  Note that I'm using Access 2003.. perhaps the SQL is a bit different?

it's giving an error on " days_diff, count(*) occurances"
nevermind.. figured it out... just have to add "as"
i.e. AS days_diff and AS occurances..

:)
thank you kindly.. .