RE: cannot join on memo field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Fields have to be the same type to join.
Try using a hyperlink field in both tables.
--
KARL DEWEY
Build a little - Test a little


"jacobk" wrote:

Hi all,

I have a problem, which I'm stuck with.
If somebody has a suggestion, please help.

The situation:
I have a database for intranet logging where I import data in tblURLs from a
.txt file with about 300,000 records a time (3 months). The URL-field must be
a Memo field (more than 255 characters sometimes). This field is not unique,
it repeats many times in the table.
I've added an ID (autonumber to the table).

The second tabel, tblStructure has also the URL-memo field with the same
data from the first, but filtered to be unique.
This table has also other fields, say level0, level1, level2 and URL.
I use this table to get the structure of the intranetsite translated to URL's.

The problem:
I like to see the intranet structure in my crosstab query in stead of the
URL's.
P.e. The structure "support" is covered by the urls:
/intranet/boston/support, /intranet/texas/support and
/intranet/houston/support.
I want to convert the urls back to the structure.

I tried with different joins: no success: cannot join on memo field.
I tried with a DLookup in the query: no success, gives errors.

Anyone any suggestions ? I'm stuck a little bit now...

Thanks in advance,

Jacob.

.