Form Grouping

Posted on 2005-05-06
Last Modified: 2008-03-06

I am not sure if I can group in a form like I can in a report because I do not see the sorting and grouping button.  I have a form I want to group according to whether or not the deal is  <30 days from current date (this is <30 days ago), >30days but less than 60 days (this is in the future), and greater than 60 days.  

I have two text  boxes named "txtPrinicpalPmtStart"  and "txtInterestPmtStart"
If either of these text boxes have a date that is in my range above I would want it to be grouped together and have a heading.
I want a particular deal to be grouped under the certain grouping criteria I have.  

Not sure if I am explaining this in depth enough.  I am not a programmer.  

Thank you
Question by:Petrobras
    1 Comment
    LVL 65

    Accepted Solution

    'Sorting and Grouping' is only available in reports, not forms.

    You'll have to create three subforms, each bound to a query that is able to generate the data 'whether or not the deal is  <30 days from current date (this is <30 days ago), >30days but less than 60 days (this is in the future), and greater than 60 days'.

    Hope this helps.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Report events not being triggered 8 67
    Concatination in Sample DB 14 51
    VB Access SQL question 2 17
    VBA exception error 5 25
    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now