Hi Ive tried negating it by adding another single qoute mark - it doesn't come up with the error but when I click on the search button , it is...

(SE.LastDate >= DATEADD(m,-12,getdate()) )

Would this get the results from 12months upto today?

I still don't understand any examples please I would appreciate it thanks

the rough table struct for Query1

tblSicknessEpsisode tblSmsStaff StaffSick ...

The second query should pull back info from the first and itself. so the second query will match on the first and pull this like First Date, Last Date ,etc

At...

Help - it does not work within a view as it does not accept case statements

this works but i need to add another condition !

SELECT CASE WHEN CurrentSickTerm= 'LT'THEN 'Long Term' ELSE if CurrentSickTerm= 'ST'THEN 'Short Term' else 'NULL' END AS ColumnNameFROM...

Thanks very much -you saved me once again

Regards

thanks very much .

Much appreciated

Regards

Ritesh

expression entered has a function containing the wrong number of arguements

expr1:isnull(LastDate,getdate())

This is what I used and does not work

SELECT isnull(LastDate,getdate()) AS Expr1, tblSicknessEpisode.SickEpisodeID, tblSicknessEpisode.PersonnelNumber

FROM tblSicknessEpisode LEFT JOIN tblSMSStaff ON tblSicknessEpisode.PersonnelNumber = tblSMSStaff.[Personal Number]

GROUP BY tblSicknessEpisode.SickEpisodeID, tblSicknessEpisode.PersonnelNumber;

quick question hope you can help. In access I hava table that contains a last date.. Some records have a null value..

I'm writing a query to say if the date...

thanks very much Ramesh this has helped..I might have to bother you with further question later on.

Thanks ,regards

Ritesh

That will not work as I want to get a count of the personnel no.

This shows the personnel no twice. but the count result is 1 . it should show...