Export to excel using certain criteria.

[paul123456]

I am trying to export data based upon a query..the kicker and the problem i am having is that I need to export using 2 queries because of the different criterea..and the problem is that is it asking my between statement twice...enter start number..and enter end number. I would like it to only ask for the criteria once and use the criteria to run 2 different queries.

is there a way to specify a criteria for 2 different queries and export them both two 2 different files? right now its basically asking me twice for the information...

Thanks, PAUL

 

[PHV]

You may take a look at the Parameters collection of the QueryDef object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884