sorry lutz missed your edit

trying now..

lutz

I get an

An expression of non-boolean type specified in a context where a condition is expected, near ';'.

thanks ken..but I don't think that's right...I get zero rows back (I know there are records)

I think I figured it out, thanks guys.

thanks everyone..

shouldn't I be able to simply add 'GETDATE()' to the default value or binding of the table, so it inserts the current date when a record gets inserted?

Lynn

if I add that in the default value or binding..it doesn't auto fill it for me when I insert a record into that table

no I don't know how to do that can you explain?

Thanks for answering..

I think the issue is I'm trying to insert 'empty' into a datetime column...

Should I have the vender change the empty's to 'NULL'?

Makes sense thanks!

This is for ad-hoc reporting and is one big 'flat table'.

So, I never know what fields they could pick, they could pick any or all of the 400 columns.

Long story...

I as really hoping there was a user guide already out there somewhere...

Report Builder 2.0

Im really looking for a guide for my end users on the ad hoc portion of report builder only..

not intersted in giving them a report making guide..

Thanks for answering...

I should have explained better..there are three pkeys on this table..

loanid

data_date

loan

loanid is identity

data_date - I need to insert

loan - is coming from text file

I was hoping there was...

Howardw-

Thanks sooo much that was it !!!

Good karma to you!