Help for a beginner with tables and reports

[Amazingmin]

Hi everyone,


This is my first post here. I'm a raw beginner at Access, and I'm using Access 2007. What I want to do sounds fairly simple but my limited knowledge is stopping me. What I want to do is to create a table with data, (I can manage that OK !) then be able to select multiple rows from that table, and put them into a report that can be printed. If anyone could point me in the right direction I would be most grateful.

[trevor40]

At the very basic level you could try the report wizard, just follow the prompts. then try the query wizard, and use this to filter the required records, then base the report on the query.

[orange]

Trevor has certainly identified the basics. Have you tried google and youtube to find some instructional videos? There are many out there -- 599CD has a full set on intro to Access 2010.
Good luck.

[Amazingmin]

At the very basic level you could try the report wizard, just follow the prompts. then try the query wizard, and use this to filter the required records, then base the report on the query.

Thanks for the advice so far, it is very much appreciated. I have been studying tutorials etc. and I'm beginning to pick up some of the fundamentals. I can run some simple queries, but what I need to be able to do is manually select rows of the data and send them to a report for printing. Sounds simple, and it probably is, but I can't find a solution anywhere so far......

[June7]

Sorry, Access tables/queries won't work that way. A spreadsheet allows manual selection of rows and printing the selected rows.

In Access have to filter records in table/query. That filtered query can be the RecordSource for a form or report.

[trevor40]

Ok you could try this,
add a field to your table called chk_to_print as a yes/no field type
Also add the to your form, you could then select the records you want to report on by filtering the report by that field,
if you have based the report on a query, add the field the query as well and then in the critera for that field enter yes or no to see only those records in the report

[trevor40]

my mistake, use a true/false field for this and set the criteria to true or false

[Amazingmin]

my mistake, use a true/false field for this and set the criteria to true or false

There isn't a "True/False" field option in the drop down list in access 2007?

[trevor40]

brain! mixied up with vba

[orange]

How do you identify the records you want to print?
Create a query to select those and use that as the recordsource for the report.

OR
Create a filter on the existing recordset and apply the filter when you Open the Report

see Report OpenArgs (use Google)

[Xipooo]

First, create and save a query that selects those fields you want to display on your report.
Second, create a new report and add a TextBox for each field in the "Details" section of the report.
Third, in the RecordSource of the report, select the query you created in step 1.
Fourth, in each TextBox go to the properties of the text box and under the "Data" tab, in the "Control Source" option type in the name of the field from your query that you want to display in that text box.

[Amazingmin]

Thanks everyone for your help. Trevor's solution worked great for me, but I'll try the other ideas as well to see how they work too.