want to set up query to get data from access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a query (access 2003) using two columns. One column
'date of referral' and other column 'date of assessment'. Need to pull out
people who have gone over 15 day wait from referral to assessment. Is this
possible as referral dates/assessment dates are different for each person.
Can anyone help!!!!

Many thanks
 
Using the function DateDiff you can get the different between the two dates
in days, and then add a criteria to it >15

Something like

Select * From TableName Where
DateDiff("d",[date of referral],[date of assessment]) >15
 
Back
Top