Topics Search

Concatenate two fields in a query in Access 2007

Concatenate two fields in a query in Access 2007
Views: 219
In Access 2007, I have a database and I need to know how to concatenate two fields when creating a query. I need to be able to see these two concatenated fields in my query result set.
Sponsored Links:

More topics

 

Concatenate two fields in a query in Access 2003

Preview
In Access 2003/XP/2000/97, I have a database and I need to know how to concatenate two fields when creating a query. I need to be able to see these two concatenated fields in my query result set.
 

can you concatenate in Access?

Preview
I realize after much importing/data entry that we need to concatenate two first name and last name columns, and bottom line, turn four columns into two. In Excel, it's easy, just concatenate and replace what you need.

Can this be done in Access? Or would I have to export it all out into Excel (although I've got 2007, it is a VERY large file), concatenate there then upload itall?
 

Concatenate first name and last name fields with a space in the middle

Preview
This MSAccess tutorial explains how to create a query to concatenate the first name and last name fields together separated by a space in Access 2003 (with screenshots and step-by-step instructions).
 

Concatenate first name and last name fields with a space in the middle in Access 2007

Preview
how can I concatenate the first name and last name fields with a space in the middle?
 

Query to concatenate fields and then insert into existing table

Preview
I have a table that has FirstName and LastName in it. I would like to concatenate them to be FullName and then copy the FullName field into a table. I am able to succesfully concatenate using SELECT FirstName & LastName AS FullName but cannot figure out how to reference the query results and INSERT them into tblEmployees.

I've looked at DLookup a bit but im not sure that is the correct route to go.
 

Create queries for a new Access 2007 database

Preview
Learn how to create queries. In Access 2007, you use queries to extract data from your database, and to provide data for forms and reports.
After completing this course you will be able to:
1)Use the Query Designer to create a select query that returns data from a single table.
2)Create a select query that asks you to enter parameters, then returns results that match those parameters.
3)Use a formula in a query to calculate a sum.
4)Use the Query Wizard to create a select query that returns data from two tables.
5)Use a text expression to concatenate fields.
 

Concatenation to blank fields

Preview
I have this expressions in a query - if seems if some of he fields are blank it does not concatenate the other fields - how do I get them to concatenate if there are blank fields?

ReportDesc: [KaratWeight]+" "+[Description]+" "+[Size]+" "+[TypeOfLeaf]+" "+[GramWeight]+" "+[Classification]
 

Moving from Access 2010 to Access 2007 (Calculated date fields and queries)

Preview
Right, I now have to develop in Access 2007 environment and I am kind of stuck.

In Access 2010 you can have calculated fields in tables. I created Calculated fields to autocalculate the month name from dates and then I use that fields easily in the Query wizard.

Now that Access 2007 doesn't support Calculated fields how should I tackle this problem? Specifically how do I create a query that is able to group results into months from a date field
 

concatenate records in the same field

Preview
Strange question, I know, but just curious to know if it's possible to do it.

In my query I have a column where I can concatenate two fields:

ValidationReference: [City] & " " & "|" & " " & [Postocode]

However, If I wanted to concatenate data in just one field, say, [Postcode], how would I go about doing this?

So it would look something like this:

Column 1 | Column 2
London | Postcode 1 | Postcode 2 | Postcode 3

Ideally I would like to accomplish this in query design
 

Concatenate a string

Preview
Can Someone Please help.
I want to Concatenate in my Query a textBox the CL-No's by WorkOrder and by DrawingNo.
I have a query with WorkOrder, DrawingNo, ClosureWeldNo, and some other stuff.
For this Query I have 2 tables - 1 is WorkOrder tbl (With WorkOrder in) and The other is Welds tbl (With DrawingNo And ClosureWeldNo).

I am using Duane Hookom's Concatenate Module.

I am using this right now in my query
CL-No:Concatenate("SELECT DISTINCT[ClosureWeldNo] FROM [Welds tbl] WHERE WorkOrderID =" & [Welds tbl].[WorkOrderID])

It Concatenates by the WorkOrder But I want It to Concatenate by DrawingNo and WorkOrder. (I may have up to 5 drawings in each WorkOrder).

I am not sure how to ad this extra statement by DrawingNo into this