Relating Fields

JB_96RS

Registered User.
Local time
Today, 16:08
Joined
Jan 13, 2004
Messages
15
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
 
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?
 
Strange. Can you post a small subset of your database with a few records in the two tables and the query you have now?
 
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.
 
Here is my sample

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


Thanks,

JB
 
Last edited:
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
 

Attachments

Users who are viewing this thread

Back
Top Bottom