Exporting Data from Table

[russellporter]

I have a form which contains a subform.

This is linked by the primary key



The subform logs all jobs that have been done during a certain time.

I want to be able to export the data to excel using the primary key in the table, sometimes there might be 5 records in the subform but others there may be more.

I know how to export all the data, but cannot figure out to export just the records for the time.

Any help would be appreciated.

[pbaldy]

You should be able to create a query with a criteria on the primary key field that refers to the form, and export that.