Transfer spreadsheet, Main tbl and details tbl?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I need a way to transferspreadsheet may main table "Account" and my details
table "Accountsubform" by date to a floppy disk. I know how to do this, The
problem is that my details table does not have a date field, the main table
does. The main table and the details table have a relationship of
[AccountID] and [DistrictID] with referential integrity, cascade deletes and
update. How can I do this by a date range? Thanks...Randy
 
you can write a query, linking the Account and Accountsubform tables, and
setting criteria on the date field in the Account table. in the query design
grid, remove the checkmark from date field, so that the field is not
included in the output. run the TransferSpreadsheet action on the query,
rather than on the table.

hth
 
That was easy, Thanks Tina
tina said:
you can write a query, linking the Account and Accountsubform tables, and
setting criteria on the date field in the Account table. in the query
design
grid, remove the checkmark from date field, so that the field is not
included in the output. run the TransferSpreadsheet action on the query,
rather than on the table.

hth


Randy said:
I need a way to transferspreadsheet may main table "Account" and my details
table "Accountsubform" by date to a floppy disk. I know how to do this, The
problem is that my details table does not have a date field, the main table
does. The main table and the details table have a relationship of
[AccountID] and [DistrictID] with referential integrity, cascade deletes and
update. How can I do this by a date range? Thanks...Randy
Click to expand...
Click to expand...
 
you're welcome :)


Randy said:
That was easy, Thanks Tina
tina said:
you can write a query, linking the Account and Accountsubform tables, and
setting criteria on the date field in the Account table. in the query
design
grid, remove the checkmark from date field, so that the field is not
included in the output. run the TransferSpreadsheet action on the query,
rather than on the table.

hth


Randy said:
I need a way to transferspreadsheet may main table "Account" and my details
table "Accountsubform" by date to a floppy disk. I know how to do
Click to expand...
this,
The
problem is that my details table does not have a date field, the main table
does. The main table and the details table have a relationship of
[AccountID] and [DistrictID] with referential integrity, cascade
Click to expand...
deletes
and
update. How can I do this by a date range? Thanks...Randy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top