Concatenate two fields in a query in Access 2007
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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?
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.
I've looked at DLookup a bit but im not sure that is the correct route to go.
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
ReportDesc: [KaratWeight]+" "+[Description]+" "+[Size]+" "+[TypeOfLeaf]+" "+[GramWeight]+" "+[Classification]
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
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