ONE_IN_N

When used within a query the function produces a recordset that contains a sample of records. When used within a virtual field the function will return True for records that match the criteria given and False for those records that do not.

ONE_IN_N ( <table_name or expression>, <nvalue>, <offset> )

• table name or expression: Can be either a table name, or an expression (a query string or another query domain function) resulting in a recordset.

• nvalue: A number representing the systematic frequency at which to sample records

• offset: A number representing the record at which to start sampling, as read from the first record in the table