Exporting selected rows of data from database table

[Krish]

Hi,
I have a database table with several rows of data. How do I use a macro to
select only a few of the rows of data and export them to microsoft word? When
I looked at the "creating macro" feature in help, I found only entire tables
or queries can be exported. I will be selecting the rows manually... also
will it be possible select some of the forms and export them alone...
thanks for your help...

 

[Eric Blitzer]

You could add a Yes/No Checkbox field in your database. Display that on the
form. Create a query with the criteria for that check box = Yes. Use that
query in your macro to export to Word. After the export you would run an
update query changing the check box to no.