QUERY

[Gambler]

When i connect PL1 and PL5 in a relationship ( Trk ,Date, Race and Prog #) all is ok. When I connect the trainer report to them. I get a message. Type Mishmatch In Expression. What am i doing wrong?
Thanks
ed

[Rick]

Check your field definitions in your tables.

The fields you are using in the relationship have to be defined the same.

Check date first. Make sure it is Date/Time and not Text.

[AwolAtHTR]

Mon 9 Aug 04

hi Gambler,

I agree with Rick about checking the field type definition but you said PL1 and PL5

well, IF you match the field definitions and the relationship still fails,
THEN try this: use BUILD and the VAL( ) function for criteria.

specifically: REMOVE the PL1 to PL5 from the table relationships, THEN,

A. in the column for your PL1 field, RIGHT CLICK the Criteria row and LEFT CLICK BUILD

--wait for EXPRESSION BUILDER
B. in the expression box, type VAL(

C. in the left lower pane, click the + for the TABLE that has PL5

D. in the middle pane, find the PL5 field and LEFT CLICK
---the full field name should be in the EXPRESSION BUILDER pane,

E. click to right of PL5 field name and TYPE the ), ie RIGHT PARENTHESIS.
---in other words, this is the end of the VAL() function

F. click OK for the EXPRESSION BUILDER

----now the VAL(--of PL5--) should be your matching criteria for PL1

NOTE: this is using Access 2.0, so your version my have different pane windows
--------BUT, the method SHOULD work with later versions.

This is the workaround that I have used when the relationship failed and it has worked
for both numeric VAL() and text MID(). That is, when your matching criteria is a text field
you have to use the MID() function for whichever part that you are matching.

well, maybe you not need this but let me know if you try it.

aaah, yes, IF the simple solution of --match field type-- works
THEN, why hassle with the AWOL solution!!

[Gambler]

That was the problem.
Thanks Rick
ed