after a bit of head scratching I installed the app to a different virtual directory on the same server and it worked fine...so I deleted the original app and redeployed...

I think the outer join will not work if you have fields from the Trips table in the WHERE clause...(not sure though

Hi

Sounds like you just need to use an OUTER join between Days and Trips tables

eg. FROM Days LEFT JOIN Trips ON Days.Date = Trips.Date

this will include all rows from Days even...