query

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hello,

I'm joining two table in a query. One field is text, and the other is a
memo field. It won't let me run the query. How can I get around this?

Thanks for you help,
Joel
 
PERHAPS you can use an expression in the join clause

SELECT *
FROM
TableA Inner Join TableB
On TableA.TextField = Left(TableB.MemoField,255)


Second option would be to build a query on the table with the memo field
and return the first 255 characters from the memo field. Then join that
query ot the first table.

Third option try NO JOIN and put criteria in the where clause

SELECT *
FROM TableA, TableB
WHERE TableB.MemoField Like TableA.TextField & "*"

I just ran out of options.... No wait a minute

If the Memofield does not exceed 255 characters, change the field type
to text and then try the join.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thanks John! I really appreciate it!

Joel

John Spencer said:
PERHAPS you can use an expression in the join clause

SELECT *
FROM
TableA Inner Join TableB
On TableA.TextField = Left(TableB.MemoField,255)


Second option would be to build a query on the table with the memo field
and return the first 255 characters from the memo field. Then join that
query ot the first table.

Third option try NO JOIN and put criteria in the where clause

SELECT *
FROM TableA, TableB
WHERE TableB.MemoField Like TableA.TextField & "*"

I just ran out of options.... No wait a minute

If the Memofield does not exceed 255 characters, change the field type to
text and then try the join.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Back
Top