From 1 table, make a second report of part of the records

[Janet A. Thompson]

I have a table and a report based on that table. I want to create a 2nd
report that looks like the other report but includes only data of control
number 200 and greater.
The table is consecutive numbering and the first report includes all the
control numbers up to 150. For identification purposes, we are using a new
100's to distinguish different entities.

What I did: I copied the table and the report. In copying the report I
took only the format and not the data.

We want to start adding data at control no. 200 and have the second report
include only control no. 200 and greater. How?

 

[John W. Vinson]

I have a table and a report based on that table. I want to create a 2nd
report that looks like the other report but includes only data of control
number 200 and greater.
The table is consecutive numbering and the first report includes all the
control numbers up to 150. For identification purposes, we are using a new
100's to distinguish different entities.

What I did: I copied the table and the report. In copying the report I
took only the format and not the data.

We want to start adding data at control no. 200 and have the second report
include only control no. 200 and greater. How?

Base it - not on the Table - but on a Query with a criterion specifying the
records to be reported. The "zero order" solution would be to use a criterion
of

= 200

on the control number field.

For more flexibility, you can use a criterion

= [Enter starting control no:] AND <= [Enter ending control no:]

to be prompted for the range.

Better yet, create a small unbound form frmCrit with two textboxes, txtStart
and txtEnd, and use a criterion of

= NZ([Forms]![frmCrit]![txtStart]) AND <= NZ([Forms]![frmCrit]![txtEnd],999999999)

using a number greater than your Control No will ever reach.

 

[Janet A. Thompson]

Base it - not on the Table - but on a Query with a criterion specifying the
records to be reported

you mean "base it" what is it?

Do you mean keep both sets of data in one table and generate a report, using
the "grid" I copied and a query with the criterion you describe?
--
Janet A.

I have a table and a report based on that table. I want to create a 2nd
report that looks like the other report but includes only data of control
number 200 and greater.
The table is consecutive numbering and the first report includes all the
control numbers up to 150. For identification purposes, we are using a new
100's to distinguish different entities.

What I did: I copied the table and the report. In copying the report I
took only the format and not the data.

We want to start adding data at control no. 200 and have the second report
include only control no. 200 and greater. How?

Base it - not on the Table - but on a Query with a criterion specifying the
records to be reported. The "zero order" solution would be to use a criterion
of

= 200

on the control number field.

For more flexibility, you can use a criterion

= [Enter starting control no:] AND <= [Enter ending control no:]

to be prompted for the range.

Better yet, create a small unbound form frmCrit with two textboxes, txtStart
and txtEnd, and use a criterion of

= NZ([Forms]![frmCrit]![txtStart]) AND <= NZ([Forms]![frmCrit]![txtEnd],999999999)

using a number greater than your Control No will ever reach.

 

[John W. Vinson]

Base it - not on the Table - but on a Query with a criterion specifying the
records to be reported

you mean "base it" what is it?

A Form or Report has a "Recordsource" property - where it gets its data.

This can be a Table... or it can be (in fact usually will be!) a Query
selecting data from a table, or from several joined tables.

Do you mean keep both sets of data in one table and generate a report, using
the "grid" I copied and a query with the criterion you describe?

Data is *STORED* in tables.
Table data is *SELECTED AND ARRANGED* in queries.
Query data is *DISPLAYED AND EDITED* on Forms.
Query data is *PRINTED* on Reports.

Each tool has its own uses. If you're assuming that everything you want to see
must all be in one table, you're missing 97% of the power of Access!

See some of the resources here, particularly Crystal's excellent tutorial:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials