It worked! Thanks. Do you have any pointers on how to set up the Criteria to select all of the dates from a field with a date data type that belong to a certain month or certain year?
Thanks again
I have the need to select the records in a query based on the last 4 digets in a text field that are equal to a specified value. I created a Query with a parameter as follows:
Parameter Data Type
[Enter Report Year] Text
Then in my Criteria row for the field in the query I...
I have several large tables in an Oracle 8 database with primary keys that are sequence numbers. Has anyone ever created a primary key constraint forcing the index to be a reverse key index to eliminate "sliding indexes" (ie. old keys always deleted from one end of the b-tree and...
Can indexes be created for materialized views? If not, how can accessing a non indexed materialized view be quicker than accessing an indexed table even if the table has many more rows in it?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.