hi.

i was wondering if anyone can help me with my problem.
im using a linked table to populate a report. the table is linked to an SQR output in a text file. one of the fields in the text file is a date in the format 31-Dec-2006.

when i create the link and set the format of the date field to date/time, it shows up as #Num! when i open up the table in Access and it does not show up at all in the report. can anyone explain why this is happening?

on the other hand, when i format the field as text in the table, it will show up both on the table and the report properly. will i be able to make a report filter if the format of the date field is text?

thanks

You should be able to leave it as text and then create a query, as the recordsource of the report, where you convert it to a date. For example, in my query's "Field" I would type:

WhateverYouWantToCallIt:Format(CDate([YourDateTextFieldNameHere]),"mm/dd/yyyy")