Hello. I have a database for tracking people on a certain course- (students in a 4 year plan). I have a report that pulls all students that are status=in progress and the contract was received within the term & year the user inputs in the user parameter (in the Show Custom Dialog script).

I also have a similar report that pulls all students that are status=in progress and the “planner” was received within the term & year the user inputs in the user parameter (in the Show Custom Dialog script).

I need a report that pulls both…. All in progress students that have turned in the contract & planner on the term & year the user enters.

How would I use what the user enters for the year & term in the Custom Dialog Box for both the Contract & Planner (2 separate fields)?

Thanks in advance

the contract was received within the term & year the user inputs

How exactly do you formulate the find? IOW, what is recorded regarding the times the contract/planner were received?

term would be Fall, Winter, Spring or Summer and year is 2011 or 2012 (4 digit year)

so the field for contract rec'd could have Fall 2011 or Winter 2012 or Summer 2008

Supposing the user entered the term and the year into 2 global fields, this:

Enter Find Mode []

Set Field [ Status ; "in progress" ]

Set Field [ ContractReceived ; gTerm & " " & gYear ]

Set Field [ PlannerReceived ; gTerm & " " & gYear ]

Perform Find []

will find students in progress that have submitted both the contract and the planner within the specified term - while this:

Enter Find Mode []

Set Field [ Status ; "in progress" ]

Set Field [ ContractReceived ; gTerm & " " & gYear ]

Duplicate Request

Set Field [ ContractReceived ; "" ]

Set Field [ PlannerReceived ; gTerm & " " & gYear ]

Perform Find []

will find students in progress that have submitted the contract and/or the planner within the specified term .