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,
Seiya
by Seiy » Fri, 30 Nov 2001 03:22:42
Seiya
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