I have set up the relationship between two tables in my query. The field is a Lot ID and it is in this format.... "2-11000". Sometimes there is "E" at the end of this. Question is: How do I make the query think that the two fields are the same even if one contains an "E"?


Thanks,

JB

Here's how: Linking Tables with similar words (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=58470)

I've tried this following the above link, but I cant seem to get it to work. I entered this into the criteria for one of the tables (scribe table)

Like [particlefiles].[lot] & "*"

Particlefiles is the other table. Both contain a field "Lot", but sometimes the number in Particlefiles contains an "E".

Any ideas?

What happened when you tried the above?

It returned no records

Strange. Can you post a small subset of your database with a few records in the two tables and the query you have now?

Not sure how to do that.

Just make a copy of your db, then cut out all the tables and queries that don't pertain to the problem. The post it by attaching it to your posting in zip format.

I have tables that are linked to a SQL server that relate to this problem. Will that be an issue?

I would suggest that you create yourself a small sample db where you create two tables with the same setup as an in the db where you're having a problem. Then try to link the 2 using the query method you tried. See what happens. Post your results.

The forum doesnt seem to want to let me upload my file!! Can I email it?


Thanks,

JB

Did you try posting it in zip format? It won't accept uploads in mdb format.

I zipped it and attatched it..but it doesnt show.

Ill try again