AspWebSolution Forums » Products » ASP Report Wizard v2

index | search | no replies | posting guidelines | help

» »

:: Possible Bug: Doing a JOIN :: (3)

Sep 13 2004, 6:35 AM

Possible Bug: Doing a JOIN

dwpfister

from: NY Started evaluating the reporting tool, and very happy with the feature set. One issue that I've run into:

Access database with multiple tables
Master table "Projects" has a field "ID" which is an Autonumber field
All other tables have a field "ProjectLinkID" which is a Text field

The projectlinkID field is simply a hook back to the original project. My application works fine with this methodology, without any issues with type mismatches.

However, when I try to create reports with the reporting tool and specify:

[projects].[ID]=[projectnotes].[ProjectLinkID]

I get "Type mismatch in expression." when I run the report.

I'm assuming it's because the [projects].[id] is an Autonumber, and the [projectnotes].[projectlinkid] is a Text field. If I, for testing purposes, set [projects].[id]=[projectnotes].[id], it works fine (although I don't get the correct data in the report since the two records aren't related.

Any workarounds?

Sep 13 2004, 7:50 AM

Re: Possible Bug: Doing a JOIN

Post a Reply

ghost

from: Washington, DC The reason you are having a type mismatch error is because Access cannot create a JOIN for fields with different data types. You will have to change the ProjectLinkID data type to Number

-------------------------
Ghost

Sep 13 2004, 1:30 PM

Re: Possible Bug: Doing a JOIN

Post a Reply

dwpfister

from: NY Thanks..that was it.. If I treat it as a numeric, the reporting works fine..

Pages: (1) [1]