Results 1 to 2 of 2
  1. #1
    bgus is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    8

    Problem with Select DistinctRow

    Am having a Select DistinctRow recordsource problem.



    I have 2 forms and a subform
    1. Form Attendees (one to one) has a control button that calls
    2. Form Registration (one to many)
    The data from Registration should show up on the
    3. subform on the Attendees form.

    The subform properties has a SelectDistinctRow statement under Record Source that has extra tables/fields in it that used to be in the database template but that I took out of the relationships table. Here is the statement but I don't know how to modify it:
    SELECT DISTINCTROW Registration.RegistrationID, Registration.Confirmation, Events.EventName, Registration.AttendeeID, Registration.EventTypeID, Registration.JobTypeID FROM Events INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON Registration.RegistrationID=[Sum Of Payments Query].RegistrationID) ON Events.EventID=Registration.EventID ORDER BY Registration.RegistrationID;


    If anyone can assist w/the correct SELECT DISTINCTROW statement, that would be great.


    Attached are bmps of

    • Attendees table showing the subform #3 above
    • current relationships table
    • design view of Relationships form that the attendee form calls (and the data from which feeds into the subform)



    I am not sure how else to show the database. Is there another way to export a simplified version of the db to post to the forum?


    TIA for any help.

    Betsy

  2. #2
    bgus is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    8

    SELECT DISTINCTROM prob, cont.

    The attachments either exceeded the dimension or kb size limitations. Not sure how to communicate the problem. Suggestions welcomed. Thank you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Select value from a list box
    By Hidenite in forum Queries
    Replies: 8
    Last Post: 01-29-2010, 11:31 AM
  2. Field Select
    By RaptureReady in forum Forms
    Replies: 1
    Last Post: 01-28-2010, 08:29 PM
  3. SELECT returns more than one row
    By 83dons in forum Queries
    Replies: 1
    Last Post: 01-13-2010, 11:28 AM
  4. SELECT problem with apostrophies
    By BPak in forum Programming
    Replies: 7
    Last Post: 07-06-2009, 07:22 AM
  5. SELECT FUNCTION help please
    By scott munkirs in forum Queries
    Replies: 0
    Last Post: 10-17-2006, 07:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums