Good resources for tutorials?

[JPP]

Hi everyone. I need to figure out how to create a report that can be printed. I'm selling things, and I want to see how much I paid for it and how much it sold for, or more in depth how much profit I made?



Any good links for tutorials on creating a report?

[Rainlover]

Any good links for tutorials on creating a report?

It is not just the Report you need to concern yourself with.

If you don't put the data into the Database properly you will never get it out easily.

Have you been able to create a Query that hase the information you want in the Report.

[JPP]

Nope. At the time of this posting I wasn't even sure a query was needed. The table is good, built with 10 fields and a form is created and linked to the table so whenever I need to create a new entry, I can do so. NOW what I need to be done is find a way for me to be able to view individual records in a nice, printable form

[Rainlover]

If only one Table is required then there is no need for a query. Just use the table for the Record Source.

To create a good looking report requires changing fonts, making some things bold. Perhaps a Box around some other things.

You can start by using the wizard to create a basic report then change things for a better look.

Unless you have a particular problem I don't know how else to help you.

So feel free to post back with any problem.

[JPP]

If only one Table is required then there is no need for a query.

AHHHH... This is contradicting everything I've been told. So for a very basic table with a very basic form, HOW do I get a report to display a search box so I can search an order number, get that one single order pulled up in a printable format?

[Rainlover]

Now you need not only a Query to Filter the records, but also a Form to display which record you want to report on.

So create a Form with a Combo Box to select the record you want.

As a Criteria in the query use the expression builder to select the Combo on the form.

Use this query as the record source for the report.

See how far you can get.I am off for now. I will have a look in a few hours time if no one else has helped you.