report question

[chand]

Hi

i am doing .net application and one of my user is creating access reports.
sqlserver is default datetime value as 1/1/1900.when user doing reports she is getting 1/1/1900. how can user display blank instead of 1/1/1900 in access reports

thanks

 

[Joe Mamma]

Hi

i am doing .net application and one of my user is creating access reports.
sqlserver is default datetime value as 1/1/1900.when user doing reports she is getting 1/1/1900. how can user display blank instead of 1/1/1900 in access reports

thanks

are you sure the default in the database is 1/1/1900 and this is not a case of misformating null in the report?

check out the isnull function as well as the case statement