Excluding item from report

[Etty]

I am a new user of Access. I have a database that has a
field called Insurance CO. In that field I enter a number
of insurances names. How can I run a report for one the
insurance company ONLY?
Right now it sorts them and puts the records of the chosen
insurance Co first and the others below it. I want all the
other insurance companies records to be completely
excluded.

Thanks

Etty

 

[guest]

try putting this under the report criteria: select the CO ID field
and put [forms]![formname]![CO]

 

[Kurt]

-----Original Message-----
I am a new user of Access. I have a database that has a
field called Insurance CO. In that field I enter a number
of insurances names. How can I run a report for one the
insurance company ONLY?
Right now it sorts them and puts the records of the chosen
insurance Co first and the others below it. I want all the
other insurance companies records to be completely
excluded.

Thanks

If a record contains a field with more than one company,
you probably can't do as you want. You need to separate
each company with its own other attributes per record.
Kurt

 

[Annelie]

I would open the report from a form and then use a combo box, from which you
can select one company.