Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to apply filter to the report when that report OutPutTo a excel.

Status
Not open for further replies.
cin2002

cin2002

Programmer
Mar 19, 2002
29
US
I have a question. I want to export a access report to a excel file, and I want to make some filters to the report when the report is OutputTo the Excel. Anyone can tell me How I can do that?
 
Sort by date Sort by votes
I find exporting Access97 Reports to Excel vaguely unsatisfactory. It is much easier, I find, to export the underlying query and use Excel macoes to do the formatting. If you export to an Existing Spreadsheet and the data has the same fields each time the process then the whole thing can be virtuall automatic. Sandy
 
Upvote 0 Downvote
I have posted something to this thread, as has someone else both might be useful to you.

thread702-247864 Sandy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
738
hermanlaksko
hermanlaksko
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
995
PrimoSteve
PrimoSteve
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
817
TomSalvato
TomSalvato
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
713
BJZeak
BJZeak

Part and Inventory Search

Sponsor

Back
Top