Problem with Concatenate Function

[ant1983]

Hi...

I get the following error when trying to run a query that has a concatenate
thinghy in:

Undefined function 'Concatenate' in expression.

Why'm i getting this and how can i resolve?

Cheers

 

[BruceM]

Access does not have a Concatenate function. I assume a "thinghy" is an
attempt to combine field values and/or text strings. To concatenate in a
query, create a new field by adding something like the following at the top
of a blank column in design view:

FullName: [FirstName] & " " & [LastName]

It is often helpful to post some details of what you tried. For instance,
how exactly did you try to concatenate?

 

[Debbie]

Access does not have a Concatenate function. I assume a "thinghy" is an
attempt to combine field values and/or text strings. To concatenate in a
query, create a new field by adding something like the following at the top
of a blank column in design view:

FullName: [FirstName] & " " & [LastName]

It is often helpful to post some details of what you tried. For instance,
how exactly did you try to concatenate?

Hi...

I get the following error when trying to run a query that has a
concatenate
thinghy in:

Undefined function 'Concatenate' in expression.

Why'm i getting this and how can i resolve?

Cheers- Hide quoted text -

- Show quoted text -

Name: [FirstName]&" "&[LastName]
No spaces except for in between quotes one space

 

[ant1983]

Sorry for the lack of info and thanks for the replies...

I know how to do the concatenate as both of you have shown below but this is
not what i want to accomplish. Let me give you a little context:

I have an HR database which holds information about positions and
departments etc. One of these tables holds information regarding department.
Example:
- Finance
- Human Resource
- Operations (ETC)

In another table i have positions within those departments and this is
linked to the above table. Examples of these positions are: (IN Finance):
- Accountant
- Credit Controller
- Debtors Clerk (ETC)

What i want to do is run a query to show me the data like this

DEPARTMENT POSITIONS
FINANCE Accountant / Credit Controller / Debtors Clerk

Instead of the normal way where you would have the entry and then a
"Sub-datasheet" (if thats even the correct word...

So basically i want to concatenate the positions linked to each Department
but show it in one line. (If it shows in all the lines of that query thats
not a problem because i can just run a GROUP thinghy)...

Ive postecd a similar questions before. If you want to refer to it the
Subject line is:

"Query Results Next to Each Other "

I was advised to download an example database and in that database is
exactly what i want to do but if i copy that (the concatenate thing) over to
my database i get the error i was talking about. (Even though i replicated
exactly what they have done)

PLS HELP and again sorry for the lack of info. Im always paranoid that if i
write too much people wont bother reading it...

Cheers!

Access does not have a Concatenate function. I assume a "thinghy" is an
attempt to combine field values and/or text strings. To concatenate in a
query, create a new field by adding something like the following at the top
of a blank column in design view:

FullName: [FirstName] & " " & [LastName]

It is often helpful to post some details of what you tried. For instance,
how exactly did you try to concatenate?

Hi...

I get the following error when trying to run a query that has a
concatenate
thinghy in:

Undefined function 'Concatenate' in expression.

Why'm i getting this and how can i resolve?

Cheers- Hide quoted text -

- Show quoted text -

Name: [FirstName]&" "&[LastName]
No spaces except for in between quotes one space

 

[BruceM]

Access does not have a Concatenate function. I assume a "thinghy" is an
attempt to combine field values and/or text strings. To concatenate in
a
query, create a new field by adding something like the following at the
top
of a blank column in design view:

FullName: [FirstName] & " " & [LastName]

It is often helpful to post some details of what you tried. For
instance,
how exactly did you try to concatenate?

Hi...

I get the following error when trying to run a query that has a
concatenate
thinghy in:

Undefined function 'Concatenate' in expression.

Why'm i getting this and how can i resolve?

Cheers- Hide quoted text -

- Show quoted text -

Name: [FirstName]&" "&[LastName]
No spaces except for in between quotes one space

Did you test that before you posted? Using Access 2003, if you write it
without spaces in the query design grid Access will change it so that there
are spaces. Same if you omit the spaces in the SQL.

 

[BruceM]

When you ask about a custom function you really need to provide some detail
right away. It's true that too much information could make people reluctant
even to read the problem, but too little will tend to elicit responses based
on guesses. Excel has a Concatenate function, so my guess was that you had
tried the same thing in Access.

Is the code you tried anything like what is posted here?
http://www.mvps.org/access/modules/mdl0004.htm

The problem remains that "Concatenate" is not defined. You would need
something in the code that starts:
Public Function Concatenate(...

or maybe:

Function Concatenate(...

You need to define "Concatenate" before Access can use it. Please post a
link to the sample database, or post the code you used along with a
description of how you attempted to use it in a query.

Sorry for the lack of info and thanks for the replies...

I know how to do the concatenate as both of you have shown below but this
is
not what i want to accomplish. Let me give you a little context:

I have an HR database which holds information about positions and
departments etc. One of these tables holds information regarding
department.
Example:
- Finance
- Human Resource
- Operations (ETC)

In another table i have positions within those departments and this is
linked to the above table. Examples of these positions are: (IN
Finance):
- Accountant
- Credit Controller
- Debtors Clerk (ETC)

What i want to do is run a query to show me the data like this

DEPARTMENT POSITIONS
FINANCE Accountant / Credit Controller / Debtors Clerk

Instead of the normal way where you would have the entry and then a
"Sub-datasheet" (if thats even the correct word...

So basically i want to concatenate the positions linked to each Department
but show it in one line. (If it shows in all the lines of that query
thats
not a problem because i can just run a GROUP thinghy)...

Ive postecd a similar questions before. If you want to refer to it the
Subject line is:

"Query Results Next to Each Other "

I was advised to download an example database and in that database is
exactly what i want to do but if i copy that (the concatenate thing) over
to
my database i get the error i was talking about. (Even though i
replicated
exactly what they have done)

PLS HELP and again sorry for the lack of info. Im always paranoid that if
i
write too much people wont bother reading it...

Cheers!

Access does not have a Concatenate function. I assume a "thinghy" is
an
attempt to combine field values and/or text strings. To concatenate
in a
query, create a new field by adding something like the following at the
top
of a blank column in design view:

FullName: [FirstName] & " " & [LastName]

It is often helpful to post some details of what you tried. For
instance,
how exactly did you try to concatenate?





Hi...

I get the following error when trying to run a query that has a
concatenate
thinghy in:

Undefined function 'Concatenate' in expression.

Why'm i getting this and how can i resolve?

Cheers- Hide quoted text -

- Show quoted text -

Name: [FirstName]&" "&[LastName]
No spaces except for in between quotes one space