Solved*****How embarrasing,,,I recently had to switch dev machines, drive failure imminent and the project was looking at the wrong dev machine over the network!!!

I just added a new field duedate datetime not null default ('')

On deployment or production machine, no problem, but on my local dev machine I get: An exception was caught during the execution of a retrieval query: Invalid column name 'duedate'. Invalid column name 'duedate'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception."}

I've deleted project and everything and regened over and over. Heellllp!

this is the query with variables specified inline, but it runs fine in query: Query: SELECT * FROM ( [oal].[dbo].[samplerequest] INNER JOIN [oal].[dbo].[sampleresult] ON [oal].[dbo].[samplerequest].[id]=[oal].[dbo].[sampleresult].[sampleid]) WHERE ( ( ( [oal].[dbo].[sampleresult].[testid] = @Testid1 AND [oal].[dbo].[sampleresult].[complete] = @Complete2) OR ( [oal].[dbo].[sampleresult].[testid] = @Testid3 AND [oal].[dbo].[sampleresult].[complete] = @Complete4) OR ( [oal].[dbo].[sampleresult].[testid] = @Testid5 AND [oal].[dbo].[sampleresult].[complete] = @Complete6))) ORDER BY [oal].[dbo].[samplerequest].[duedate] ASC,[oal].[dbo].[samplerequest].[batchid] ASC,[oal].[dbo].[samplerequest].[sampleid] ASC

Thanks, Terry