Reports using Access

  • Thread starter Thread starter Praveen Manne
  • Start date Start date
P

Praveen Manne

Hi,

I want to generate reports from the database using access. This is the
scenario ..

I have a table which has 200 fields and more than 500 records in it.
I want to create a report which will only show the fields for each record ,
which contains some value (i.e the fields in a record with value 0 or Null
should NOT be populated.) . Can this be done in Access?

Thank you ,
Praveen Manne.
 
Praveen said:
Hi,

I want to generate reports from the database using access. This is the
scenario ..

I have a table which has 200 fields and more than 500 records in it.
I want to create a report which will only show the fields for each record ,
which contains some value (i.e the fields in a record with value 0 or Null
should NOT be populated.) . Can this be done in Access?

Thank you ,
Praveen Manne.
Click to expand...

Just use a query, uncheck the fields that you don't want in the report,
and in the critereon section for the records that you don't want in the
report put NOT NULL.

Hope this helps,
Lester
 
Back
Top