Linking Access tables and Dataflex tables in CR

[DanR]

I have a financial accounting database that uses dataflex files. I have created some auxiliary data files in MS Access to report on that as well. I have no problems linking Access and Dataflex files together when I am linking text fields, but every time I try to use a date field as a link between the two files, the report will not run correctly (pulls data from parent table, but not child).

I suspect the problem is due to Access tables having a "Date/Time" field and Dataflex having a "Date" field. Has anyone else run into this type of an issue. If so, have you been able to solve or work around the issue?

 

[dgillz]

Create a formula to convert your date/time field to a date field, then use a subreport linked on the formula and the date field.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[DanR]

I was going to try that, but the report I'm trying to link the table into is already a subreport. Are there any other ways to force the link or modify an access table to allow the link to read properly?