Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    Washington, District Of Columbia, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combining records (Access 2000)

    Post deleted by aetaylor

  2. #2
    New Lounger
    Join Date
    Jul 2001
    Location
    Washington, District Of Columbia, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining records (Access 2000)

    Oops - never mind - I discovered when I put the UserID as an output field in the new query, things worked better. Thanks

    I see you get the concat question a lot. Sorry - tried to pull back the message before you responded. However, I've tried to follow your instructions, but I keep getting an error - You tried to execute a query that does not include the specified expression 'Agreements: Concat("aqryIssueTeamsAgreements","FTA","[UserID] = " & Chr(34) & [UserID] & Chr(34))' as part of an aggregate function. I'm assuming there's something wrong with my Expression, but can't figure out what.

    Thanks

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

    Re: Combining records (Access 2000)

    For the first question, you can use the Concat function attached to <post#=301393>post 301393</post#>. You must copy that function into a module.

    For the second question, add a calculated column to the query that acts as record source of the report.

    IsFacilitator: [Specialty]="Facilitator"

    Sort the report on IsFacilitator and UserName (set this in the Sorting and Grouping window)

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

    Re: Combining records (Access 2000)

    Have you set the Total option for Agreements to Expression?

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

    Re: Combining records (Access 2000)

    By deleting your question, you have made this thread incomprehensible to others <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

Posting Permissions

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