DESPERATELY NEED HELP

[Guest]

Okay, I have two tables. One for Scope Changes and one for Markups.
The Markup table has the Project # and the percentages allowed for each
project.
The Scope Change table has the Project Number and the value of the changes
to each contract.

I have a query that will calculate the value of the Amount (on the Scope
change table) and multiply it times the markup. Which works beautifully.

Here's my problem. The only common link between the two tables is the
Project Number. When I try to set up the relationship between the two
Project# fields I get a "Type Mismatch in Expression". I know the problem is
here because it goes away when I delete the link. HELP!!!!

 

[Guest]

Check the tables in design view. My guess is one is numeric and one is text.
This means the database design has a flaw in it. I would suggest you
determine whether they should both be numeric or both be text and change one
of them.

 

[pietlinden]

what are the datatypes of the fields involved in the join?

Sounds like you are trying to create a join on fields with two
different datatypes.

 

[Guest]

You're right. Thanks for the help, now it works perfectly.