Transfer spreadsheet, Main tbl and details tbl?

[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

 

[tina]

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]

That was easy, Thanks Tina

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

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

 

[tina]

you're welcome

That was easy, Thanks Tina

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

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