permutation & combination of Lock and Enable properties .

[Guest]

What are different results of Lock & Enable properties, What type of SQL
query I should write to get data from data field on daily basis, monthly
basis, quarterly basis, yearly basis.

 

[Vincent Johns]

What are different results of Lock & Enable properties, What type of SQL
query I should write to get data from data field on daily basis, monthly
basis, quarterly basis, yearly basis.

There are only 4 choices (each property is either on or off); see Help
for a description.

None of them will help much in determining the time periods that your
Query will report.

If you want help in displaying (e.g.) monthly data, post an example and
somebody may be able to suggest a solution.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.