Results 1 to 2 of 2
2005-01-11, 12:48 #1
- Join Date
- Jan 2005
- Thanked 0 Times in 0 Posts
Duplicate records in a query (Access 2003)
I have created a query from multiple tables with about 10 fields. Some of the records in the query return multiple values for one particular field in the query and therefore the query displays multiple records for each one with 9 of the 10 fields identical and just one field showing a different value each time. I would like to merge the result from the differing value field into just one field (perhaps separating the differing values with commas) to show just one record each.
I have also tried to fix the problem in a report using grouping levels but I only seem to be able to set 4 grouping levels - is there an easy way of increasing this that i have missed?
I would be very grateful for any tips that you could offer.
2005-01-11, 12:55 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Duplicate records in a query (Access 2003)
Welcome to Woody's Lounge
See <post#=301393>post 301393</post#> for a custom concatenation function Concat that can be used to assemble a string of the form "Joe, Jane, Bill".
According to the help subject "Access Specifications", you can specify up to 10 grouping levels in a report. See screenshot.