Lisa-
Do you need the data from all of the imported tables or just some of them?
One of the easiest ways to create a report is to click on the Create tab, then
click the Report Wizard. You select the table you want to use in the report,
the fields you want to include, and how you want it formatted. If you want to
filter the data first, use the Query Wizard to build a query on your tables -
you can include criteria in a query to "find" the records you want - then build
a report on your query.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Nashua, NH)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lisa
Sent: Wednesday, March 07, 2012 9:24 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Looking to get started with Access - want to run some
reports
Hi all,
I am new to the group and haven't used Access.
I am looking to import Excel Spreadsheets into Access and then run a report to
only extract the data I need. Currently I am sorting through 150 excel
spreadsheets to find the data.
The spreadsheets all have the data formated in the same way with the same
headers.
I have imported some of the spreadsheets into Access, but I don't know what the
next step (how to run a report).
Is there any online tutorials on this? Does Access allow for this type of task?
Could somebody please point me in the direction of where to start building a
report?
Thanks,
Lisa
(MS Access 2007)
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar