Excluding item from report

  • Thread starter Thread starter Etty
  • Start date Start date
E

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
 
try putting this under the report criteria: select the CO ID field
and put [forms]![formname]![CO]
 
-----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
Click to expand...

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
 
I would open the report from a form and then use a combo box, from which you
can select one company.
 
Back
Top