Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100

    Unanswered: grouping on forms

    Does anyone know a way to sort and group records on a form in the same way that you can on a report?

    I want to create a continuous form that has headers grouped by date.

    TIA

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    You can't group on a form as you can on a report. Base your form on a query which takes the date as it's criteria.

  3. #3
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    You can "Sort of" make it work like a report.

    You need a Form/subform relationship.

    In the main form you need it's recordsource to be a group by query with the date as your criteria.

    In the subform you need the recordsource to be the ungrouped detail.

    then the Parent/Child proerties of the form subform are the Date.

    ie. 1 date in the parent shows multiple details for that selected date.

    HTH

    :0)

  4. #4
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    Great Idea, it might just work!

    Thanks for your help.

Posting Permissions

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