I suggest you make the final day in May the 31st (insert smiley here)
Bill Cook
Kent WA
----- Original Message -----
From: "Bob Powell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 11:40 AM
Subject: Mulit views in a form
>
> Hello Everyone:
>
> David Ebert gave me a great solution to presenting
> different ranges of date from a single file by using views
> of the file.
>
> I create two views as below:
>
> CREATE VIEW NUMBER1 AS SEL * FROM DETENTIONS WHE DETDATE +
> BET 1/1/2001 AND 5/30/2001
>
> CREATE VIEW NUMBER2 AS SEL * FROM DETENTIONS WHE DETDATE +
> BET 6/1/2001 AND 12/31/2001
>
> This command created the viewS quite nicely.
>
> I then created a new form connect to a driving table and
> located two different region and tiers for both of the
> above views. The information displays in the number1 view
> on the form but not the number2 view. Anyone got any
> suggestions. I've already reloaded the database and
> checked it with rscope. All appears to be fine.
> ----------------------
> Bob Powell
> The Hotchkiss School
> Lakeville, Connecticut
> Systems Administrator
> [EMAIL PROTECTED]
>
