How to do

K

Kutty

I could read in the news group as follows :

"Just tick the checkbox on the form for each employee you want included
in the report. Then, in the query that the report is based on, you
would put a Criteria of -1 in this Yes/No field, so only those Employees
whose checkbox is ticked will be shown on the report"

Can anybody explain in detail with example? Would appreciate your great help.

[email protected]
 
D

Douglas J. Steele

What part don't you understand? Do you not know how to create a query, or do
you not know how to use a query for a report?

To create a query, on the Query tab, select New, then Design View. Drag your
table into the top half of the dialog that appears, then drag the various
fields from the table that you need into the grid in the bottom half of the
dialog. On the line labelled Criteria in the grid under the field for the
Yes/No field, put -1 (you could also put True if you like)

To use that query instead of the table for a report, open the report in
Design view, and look at the properties associated with the report. Put the
name of the query instead of the name of the table as the report's Record
Source. (NOTE: If your query doesn't have all of the fields from the table
that you're using, or if your query renamed some of the fields, you'll be
prompted for values when the report opens. If that happens, either add the
fields to the query, or remove them from the report)
 
K

Kutty

I know how to create a query. But I dont know how to use a query for a rport.
Actually what I want to know is let me explain about my CONTACT database as
follows :
I have a table named Employees. Another table named Department.
In Employees table the fields are : Name, Department, Designation, Ext#,
Mobile#, Mail_Address.
In Department table : Department field only.
I have created form for the above. Once I need a report for one Employee I
need to print only that particular record. Once I need 2 Employees report or
specific number of Employee's records I have to print those particular
Employees' record
only. I need a facility like click the record what I need and print those
clicked ones only. I think you will tell me to do that thru query. I dont
know how to do that thru query. Would appreciate your clear explanation to
me.

[email protected]
 
K

Kutty

Douglas,
I think your explanation about report thru query will help me to print
records optionally? If so how can I do that?

[email protected]
---------------------------------------------
 
K

Kutty

Could you please explain this in detail that how to do?
Would appreciate your great favor.
 
K

Kutty

Douglas,
I have done this very successfully without going to bookstore. Thanks a lot
lot.
-----------------------------------------------------------------------------------------
 
Top