Hi,

I am trying to complete a small database that will save the result of
a query in a table with the name of the parameters of the query. And
also as a text file on c drive.

For example, I have a form that contains a command buttons eg
-'Complex'. When a user clicks on this a module runs a query called
complex and displays this on the screen. I would like to save the
query as a table with the name of the query. Ie the query uses Like
"*" & [ Enter first subject:] & "*" And Like "*" & [ Enter second
subject:] & "*" And Not Like "*" & [ Enter exclusion (type xx if
none):] to search for 2 terms and to exclude the third. I would like
to save the result of the query as say if the query was 'bird',
'feathers', not 'chicken', I would like to save it as a table called
'bird feathers not chicken'. The text file would be 'c:\bird feathers
not chicken.txt'.

I would also like the query (or the new table) to be displayed in
datasheet view. I would also like to be able to append the date to the
text file name(don't ask for much - do I?).

Hope I have given you enough information. Thanks for your assistance.

Doug