Normal Topic Table View (Sesame v1.1.5) (Read 298 times)
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Table View (Sesame v1.1.5)
Sep 12th, 2007 at 10:25pm
Print Post Print Post  
I have a table in a form, I am wanting to be able to show the record in the table via a date range for example.

LE = Date Completed
Data = 01/09/2007 (In New Zealand)

I click on a button on the Parent Form, that is titled "Two months"

And then it crates a "sort?" and show me all records that has a date in the box Date Completed for the last two months.

Can this be done or do i need v2?

Thanks once again for your help,

Regards

Drastixnz
  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Table View (Sesame v1.1.5)
Reply #1 - Sep 14th, 2007 at 2:33pm
Print Post Print Post  
Hello,

A sort spec only sorts the records in a particular order, It does not filter out records nor hide them.

If you only need the information for read-only purposes, Then the easiest way to do this would be to do it in a Report with a Subreport and program the Subreport to hide the records that are older than Two months old.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged