How to skip a record in a report?

  • Thread starter Thread starter arzie
  • Start date Start date
A

arzie

i have a report making labels. how can you make access skip a record if the
record is not complete?

for example, the record has name, address, and phone number. the record must
have all complete three entries. let's say the phone number field is blank
but the other two is not, i want access to skip that particular record and
goes to the next record to print it.

and vice versa, how can you make access print those records with incomplete
data?
 
One way to approach this is to step back one step.

Instead of trying to do this in the report, why not exclude records (or
include them) in the underlying query?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi thanks for the quick response! I've been using access for a long time, but
i'm not too familiar with queries. can you give me an idea or at least a
rough idea how queries work?

thanks!


Jeff said:
One way to approach this is to step back one step.

Instead of trying to do this in the report, why not exclude records (or
include them) in the underlying query?

Regards

Jeff Boyce
Microsoft Office/Access MVP
i have a report making labels. how can you make access skip a record if the
record is not complete?
Click to expand...
[quoted text clipped - 8 lines]
incomplete
data?
Click to expand...
Click to expand...
 
I'm pretty sure you're not asking for the Access101 class on "Intro to
Queries" <G>.

Try experimenting a bit. Click on the query tab, create a new query, and
add a single table.

Select fields from the table to include in the query. Run it.

Add a criterion for one of the fields. Run it.

Check Access HELP for (much) more information on queries.

Regards

Jeff Boyce
Microsoft Office/Access MVP


arzie said:
Hi thanks for the quick response! I've been using access for a long time,
but
i'm not too familiar with queries. can you give me an idea or at least a
rough idea how queries work?

thanks!


Jeff said:
One way to approach this is to step back one step.

Instead of trying to do this in the report, why not exclude records (or
include them) in the underlying query?

Regards

Jeff Boyce
Microsoft Office/Access MVP
i have a report making labels. how can you make access skip a record if
the
record is not complete?
Click to expand...
[quoted text clipped - 8 lines]
incomplete
data?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top