PRINTING REPORTS FROM QUERY IN EXCEL

hi. i am working first time with query and reports. i have created a
database. i have reports and query. i have a button in my form by the
name of (View reports) if a user clicks on that button it opens another
form with 3 options
1) Problems all report
2) problems resolved
3) Problems not resolved
Now what i really want is when a user clicks on Problems all report it
should go directly into excel work*** based on my query which i have
assigned and the width, column should be perfect in excel so then a
user can print. secondly same thing goes for problems resolved based on
my query which wil show all the problems which have been resolved and
should open it in excel with everything alligned and ready to print. i
know it is possible and i have been able to just print Problems all
based on report not with my query and the formatting was really bad. i
need to print reports based on my query directly in Excel work***
with everything perfectly formatted. any help will be really
appreciated.
Thanks alot

.

Quantcast