Access Reports - problem with datetime field

[LebronJames]

I am importing a txt file into my mdb. Only problem is the date value on my import is taken as a text field. If I change the text field to a datetime field it tells me type conversion error. On an Access report, is there a way that I can convert the text value to a date value? Will this be done on the report or is there a way to have a field in the table that takes that field and converts it to a date value?

 

[LebronJames]

I used cdate() in my sql query only problem now is if the field is null or blank then #error is displayed in the table

 

[PHV]

You may try playing with the IIf, IsNull and/or Nz functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Onyxpurr]

Are you importing automatically or going through the Wizard? You may want to check your import specification (if you have one) to see that it is set up correctly. Make sure it's not off by a character or something. And also make sure that the field itself is set to datetime in the specifications?