Creating an organized excel spreadsheet from Access Queries -

Creating an organized excel spreadsheet from Access Queries -

i'm having problem creating organized excel spreadsheet using study in microsoft access. have around 40 queries want able export excel spreadsheet, , want able place them how have formatted on report. i'm running few problems:

sometimes title query not show @ all. i have value must entered queries work (a date), going same queries. there way can avoid beingness prompted same value 40 times? when place query next in study design view, not place values next on spreadsheet.

what when run export on top, , want on bottom.

thanks help.

ms-access