How to skip a record in a report?

[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?

 

[Jeff Boyce]

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

 

[arzie]

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!

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?

[quoted text clipped - 8 lines]

incomplete
data?

 

[Jeff Boyce]

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

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!

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?

[quoted text clipped - 8 lines]

incomplete
data?