Creating a subset database file

Creating a subset database file

Post by Seiy » Fri, 30 Nov 2001 03:22:42

Suppose I would like to create a new mdb file copying from another mdb file,
but only some set of rows of the table in it. Do I need to read each row and
write to another file, or can I move the whole rows in one action?
Thank you,



1. Calculated subtotal of a subset of a subset in a file

I'm trying to get a calculated subtotal of a subset of a subset in a file to
appear in a calculated field.

Trades (file) (500 records)
    Account Number (text field) (50 records)
        Ticker (text field) (5 records)
            Net (number field) (5 records)

                looking for sum of 'Net' for those 5 records

Would like to have a calculated field display the sum total of the field
'Net' for all instances of a given stock in a given account.

Any ideas ???

Thanks, Scott

2. SQL* Loader problem with timestamp data

3. Creating subset in same file

4. Inserting Stored Procedure Results into a Temporary Table

5. Tool to create database subset?

6. Backup a single table using SQL-DMO

7. crash help, pgsql 7.2.1 on RH7.3

8. Create and Sychronize subsets of your Oracle Database

9. Creating Multiple Subsets Using Replication

10. Creating a data subset in a grid

11. Create Database statements (File Groups, Files, and RAID)

12. Drop down list with only subset of values from other file