Report/Layout construction

[Vicki Jule]

I'm new to FM Pro - have a database with prospects by year (text field). I want to create a report which auto filters on the current year, and then displays field details for records which pertain to only the filterered (current) year. How do I do this?

[sbg2]

I am assuming your Year(text field) holds just a 4-digit year, ie. 1992, 2003, 2005 etc., lets call your Year field MyYear just for readability.

Create a new script or add to an existing script:

Enter find mode

Set Field[MyYear; Year(Get(CurrentDate))]

Perform Find[]

Enter Preview Mode