Relating Fields

[JB_96RS]

Help needed

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

 

[dcx693]

Here's how: Linking Tables with similar words

 

[JB_96RS]

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?

 

[dcx693]

What happened when you tried the above?

 

[JB_96RS]

It returned no records

 

[dcx693]

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

 

[JB_96RS]

Not sure how to do that.

 

[dcx693]

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.

 

[JB_96RS]

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

 

[dcx693]

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.

 

[JB_96RS]

Here is my sample

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


Thanks,

JB

 

[dcx693]

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

 

[JB_96RS]

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

Ill try again