Module Error (1 Viewer)

[simongallop]

Don't want to be rude but I said check your field types:

In query Commission you have a join between [Individual Policy Holders].[Unit Number] and [Products Complete].[Units] The first is a text field the other is numeric. That is an example of joining with the wrong data type.

 

[Fastone]

These are all the same. I have checked them already (and did it again just now).
Every thing works fine @ Rich and I get the errors. Are there any libraries (accept the ones in the text) which 2000 doesn't have and 97 does?

 

[simongallop]

I have 2000 post 2000 version of your db

 

[Fastone]

Thanks, here is the version like I received it from Rich (accept it is converted to 2000)

 

[simongallop]

Having carried out the changes in my previous comment the commission query works fine!

To do the changes:

1/ Go into relationships and delete the 4 links between the tables INDIVIDUAL POLICY HOLDERS and PRODUCTS COMPLETE
2/ Go into design view of PRODUCTS COMPLETE
3/ Change the field type of UNITS to text (at present it is Number)
4/ Go back to the relationships table and relink the tables.

 

[Fastone]

Head hitting keyboard .

You are right, it is working now. I checked the links in the wrong database (I think I have about zeven copies of this thing now).

Thanks to all of you, now I know were I have to go to get some help.