How to merge multiple records into one field?

  • Thread starter Mikael Lindqvist
  • Start date
M

Mikael Lindqvist

Hi,

I'm attempting to create a query that I can use for an Access report.

The table that I'm querying has three fields, AccNo, ProjectId_first and
ProjectId_last (this is straight from the database and not something I have
control over).

Example:
4060 | 12 | 15
4060 | 17| 17
4060 | 18 | 23
5010 | 10 | 25
5010 | 12 | 25
6010 | 9 | 10

Now, I want a query that merge ALL the 2nd and 3rd field for each AccNo (1st
field), like this:

4060 | 12-15, 17-17, 18-23
5010 | 10-25, 12-25
6010 | 9-10

Any advice MUCH appreciated!

Kindly,
Mikael
Sweden
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to merge records for each unique fieldvalue in a 2nd field? 1
How to merge datarecords for each unique fieldvalue in a 2nd field 2
Merging two tables into one table 0
Subquery not integrating to query to display previous sum of quantities 3
Round up or down to nearest 5, but not 10 2
How do I have excel highlight days before & after a date on a cale 2
15 minute data to daily data 1
Modifying a complex date formual to count months 4

Top