Results 1 to 2 of 2
  1. #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.


  2. #2
    Plutonium Lounger
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts