Jump to content

Can somebody please help?


This topic is 7367 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a relational database that tracks consumers enrolled in 15 different programs. In the “Program” database I have the following fields for each program:

Enrolled (calculation, number) = NotIsEmpty(Enroll Date)

Active (calculation, number) = NotIsEmpty(Enroll Date) and IsEmpty(Cancel Date)

Cancelled (calculation, number) = NotIsEmpty(Cancel Date)

Total Enrolled (summary, Total of Enrolled)

Total Active (summary, Total of Active)

Total Cancelled (summary, Total of Cancelled)

On the main menu of the “Consumer Main Database” I would like to have a button/script that displays the name of each program. When the Program Manager clicks on the name of their program, it will find all consumers served by that program and sort them by last name. Then I would like the Program Managers to have another button/script where they can omit the records of the consumers that have been cancelled. Can somebody please help me with these two scripts? Thank you.

[ August 16, 2001: Message edited by: zenboy ]

Link to comment
Share on other sites

This topic is 7367 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    Lee Smith 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.