Form Grouping

Hello,

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
PetrobrasAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
'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.
-Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.