Hi Bob,
Couldn't you UNION the two Select statements and create one view
Ben Johansen
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bob Powell
Sent: Thursday, June 21, 2001 11:40 AM
To: [EMAIL PROTECTED]
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]
