Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Exporting Data (Access XP)

    I have a database that maintains information about volunteers for Emergency Social Services. Amongst other data it maintains (via a 1 to many relationship) a record of all the training taken by a given volunteer. The problem is that the Director would like to load that training into her Palm Pilot address book. The only field in the PP that would work is the notes field but that would require concatenating all the training for one volunteer into field. Standard queries in Access can give me the data but I land up duplicating the volunteer basic data (name, address, etc). As far as I can see in the PP there is no indexing methodology for updating a specific record.

    Any ideas how I could achieve this concatenation inside Access.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exporting Data (Access XP)

    See <post#=301393>post 301393</post#> for a custom concatenation function Concat that can be used in a query for your purpose.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Exporting Data (Access XP)

    <hr>Standard queries in Access can give me the data but I land up duplicating the volunteer basic data (name, address, etc).<hr>
    In case you never thought of it...
    If the query can give you what you need ( acc. to you quote above), but duplicates records, have you considered changing the query property to UNIQUE RECORDS?
    Switch the query into design view, right click in the tables window (not on a table), and select properties. In the query properties box, change unique records to YES!
    Regards,
    Rudi

Posting Permissions

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