Is it possible to link memo fields?

  • Thread starter Thread starter Tex
  • Start date Start date
T

Tex

I've got two tables in my database, and I'm trying to link the memo field in
one, to the memo field in the second table. Is it possible to link these
fields (if so how) and if not, do I just manually enter this data?
 
I've got two tables in my database, and I'm trying to link the memo fieldin
one, to the memo field in the second table. Is it possible to link these
fields (if so how) and if not, do I just manually enter this data?
Click to expand...

(There is maybe a more sophisticated way than this) You could try
creating a new date field in each table and pasting the memo data into
that field.
But if you really want to do a join on the memo, if the dates are
formatted identically you could use the Left function to join on the
first 10 characters (assuming the dates are in mm/dd/yyyy format,
which is 10 characters). So the SQL would look like below (you can't
do it in design view). Note that if you have one date entered as
10/1/2009 and another as 10/01/2009 they will not match. If you paste
into a date field it will, though.

SELECT [table1].[memofield2], [table1].[thingtocompare], [table2].
[thingtocompare]
FROM table1 INNER JOIN table2 ON left([table1].[memofield2],10)=left
([table2].[memofield1],10);
 
I've got two tables in my database, and I'm trying to link the memo field in
one, to the memo field in the second table. Is it possible to link these
fields (if so how) and if not, do I just manually enter this data?
Click to expand...

What kind of "link" do you have in mind? You certainly cannot use a Memo field
as a Join field in a query.

Apologies if this is too obvious but... You may be thinking that you want to
have the same memo field data in two different tables... well, you almost
certainly don't. You can easily create a Query joining two tables and display
the memo field from one in conjunction with data from the other, either on a
Form, a Report, or a query datasheet. What are the structures of your two
tables and what specifically are you trying to accomplish?
 
In addition to John V's observations, how can you be sure that the spelling
and punctuation of two memo fields is IDENTICAL?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top