Re: Join a concatenated field

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

Date: Fri, 27 Feb 2004 15:11:06 -0800

Unfortunately, the database was not that well designed - vendor designed this. I forgot to mention that I also changed the concatenated name to a primary key as there should only be one instance of the name in this table. Although, it could show up multiple times in the table that I am trying to join to.

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.

Any other ideas?
     ----- Andrew Smith wrote: -----
     
     You shouldn't need to do this if your database is properly designed, for the
     simple reason that the name should only be stored in a single location. I'm
     not sure whether it can be done or not (though I suspect it can't), but even
     if it could be done it would not be a good idea. You could easily have two
     identical names referring to two different people and your system would have
     no means of distinguishing them.
     
     "Aaron" <anonymous@discussions.microsoft.com> wrote in message
     news:35fb01c3fd7c$5a31a1c0$a401280a@phx.gbl...
> 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

  • Join a concatenated field
    ... In a query, I have joined the first name, a space ... Cannot join on Memo, OLE, or ... Hyperlink Object. ...
    (microsoft.public.access.queries)
  • update form from listbox help
    ... I have a form with a query as the recordsource. ... query I have a concatenated field which is the primary ... This form has a subform which is related to the ... Anyway I have an unbound listbox on my main form. ...
    (microsoft.public.access.formscoding)
  • Re: UNION ALL
    ... > I have to send the result by e-mail,so order the query by ... > The field that is mentioned is a concatenated field of all ... >>Randy Harris ... Detail Record 1 ...
    (microsoft.public.access.gettingstarted)
  • Re: Combo box vs. concat?
    ... Apart from you stating "text box not named" (a textbox must have name), ... based on (go to the design view of the query, ... > Have you used an Alias name for the concatenated field in the query that is ... NOT sure what Alias name ...
    (microsoft.public.access.forms)
  • Re: Combo box vs. concat?
    ... The SQL is: ... > based on (go to the design view of the query, ... >> Have you used an Alias name for the concatenated field in the query that is ... >> Source of the textbox on the ...
    (microsoft.public.access.forms)