I have provided a sample table from a budget database that has both monthly & quarterly bills that will be due.

I am experiencing problems pulling both monthly & quarterly bills due. I would like for the user to input term (ie Fall) and academic year (ie- 2011-2012) and have the results be both any monthly bills that fall between the billing_begindate & billing_endDate and all quarterly bills that are Fall 2011-2012.

I have a script List_Billing_Monthly- and it’s working- based on the c_test=Active. I would rather not have the calculated field that says pull this monthly bill. I would like to delete the c_test field and just use a script to get the correct result set, but don’t seem to be able to do that.

Any help would be greatly appreciated.

Budget.fp7.zip

I have a script List_Billing_Monthly- and it’s working

I don't think it's "working": I search for "Fall" "2011" and I see a monthly record that runs from January to March 2012 in the found set. If I understand correctly what you are trying to achieve, there must be a "map" somewhere of term start and end dates.

Yes it's "working"... I want all Fall 2011-2012. and all monthly that are between their begin & end dates (on 1 report). I just want to get rid of the "Active" and "Old budget Line" flags for monthly.... currently that's how the script pulls the monthly ones that fall in the date range.

Try it this way, then:

Enter Find Mode [ ]

Set Field [ Salary_Budget::Billing_Timecycle; "Monthly" ]

Set Field [ Salary_Budget::billing_BeginDate; "≤" & Get ( CurrentDate ) ]

Set Field [ Salary_Budget::billing_EndDate; "≥" & Get ( CurrentDate ) ]

New Record/Request

Show Custom Dialog [ Title: "Term & Year"; Message: "Please Enter Term & Academic Year"; Buttons: “OK”, “Cancel”; Input #1:

Salary_Budget::Terms; Input #2: Salary_Budget::ACADYr ]

If [ Get(LastMessageChoice) = 1 ]

Perform Find [ ]

Else

Enter Browse Mode

End If

Sort Records [ Specified Sort Order: Salary_Budget::Billing_Timecycle; ascending ] [ Restore; No dialog ]

Works like a charm.... Thanks bunches