Join a concatenated field

From: Aaron (anonymous_at_discussions.microsoft.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 13:55:02 -0800

Hi,

I need your help to figure out how to join a concatenated
field. In a query, I have joined the first name, a space
and the last name into a field (First_Name & ' ' &
Last_Name). Is there a way to convert this concatenated
field into a field that can be joined with another field
in another table? I tried to create a table and pasted
the results into the table but somehow it still seems to
remember that it is a concatenated field. I keep getting
the following message: Cannot join on Memo, OLE, or
Hyperlink Object. Does anyone know how to get around this?

Thank you,
Aaron

Relevant Pages

  • Re: Cant Include Memo or OLE Object
    ... Basically, what it is saying is that you included a memofield, or an OLE ... field in a query that uses a DISTINCT clause; ... Take the memo or OLD field out of the query. ...
    (microsoft.public.access.queries)
  • Re: Join a concatenated field
    ... The message seems to indicate that the concatenated field is a Memo, OLE, or Hyperlink Object. ... When I created the table to paste the query into, it still seems to think that it is a field other than the text that I tried to setup for it. ...
    (microsoft.public.access.queries)
  • Re: Appending one table to multiple relational tables
    ... The FindingComments field is a memo field. ... >>Cannot join on Memo, OLE, or Hyperlink Object ...
    (microsoft.public.access.queries)
  • Re: What am I missing?
    ... memo populates. ... I ran the query from the SQL view of a query in Access ... One problem with memo fields is corruption. ... I suggest opening up a new database file and creating the table. ...
    (microsoft.public.access.queries)
  • Re: Query truncates data
    ... the memo) do have primary key. ... You claim that this query do the job right ... applied just to the primary key). ... use alias for your queries, a and b, in order to make the SQL less ...
    (microsoft.public.access.queries)