help please

R

rhoneycutt

i have finally switched my excel spreadsheet over to access, (8000+ rows, 22
columns) and im trying to print out reports. i have one one large table.
no queries, and i want to be able to just make reports for all of the items
for person A, and then all for person b, etc. need some help. took me
forever to get past the text/number conversion thing for importing, and just
stuck now.
 
K

KARL DEWEY

You did not give enough information to go on in order to help you.

What is your table structure - field names and datatypes?

Do you just want a listing of the data in the database, calculations,
timeframed data, etc?
What about a report split (new page) on next person instead of having to run
them separately?
 
J

John Vinson

i have finally switched my excel spreadsheet over to access, (8000+ rows, 22
columns) and im trying to print out reports. i have one one large table.
no queries, and i want to be able to just make reports for all of the items
for person A, and then all for person b, etc. need some help. took me
forever to get past the text/number conversion thing for importing, and just
stuck now.
Click to expand...

The first thing to realize is...

Excel is one program, a spreadsheet, an excellent one at that.

Access is a DIFFERENT program, a relational database program.

Access *is NOT* Excel writ large. It requires different structures,
different logic, and different approaches.

A database with no Queries makes about as much sense as a spreadsheet
without formulas. Queries are, in other words, the essential basis of
any practical Access application.

Stop... step back... and get acquainted with how Access works. Trying
to force it into the mold of Excel will give you nothing but misery!

As requested, please post a description of your table (some major
fields for example) and indicate what type of report you wish to
generate. I can assure you it will be based upon a Query (even if it's
a query that the Report Wizard generates for you in the background...)

John W. Vinson[MVP]
 
Top