[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

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
0
Petrobras
Asked:
Petrobras
1 Solution
 
Jim HornMicrosoft 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now