Duplicate information

G

Guest

I have created a report called PreJob's which pulls information from two
different tables; Work Order Main T and Order Details T. I am pulling
information from a field called Job Description from the Work Order Main T
and Operator Name from the Order Details T, now the Operator Name can be
listed more than once under one job description but on the report I only want
to show the operator name once no matter how many times he is under that one
job description. Is this possible?
If need be I can try to give more details if the is not enough.

Thank You
Renee
 
M

Marshall Barton

Renee said:
I have created a report called PreJob's which pulls information from two
different tables; Work Order Main T and Order Details T. I am pulling
information from a field called Job Description from the Work Order Main T
and Operator Name from the Order Details T, now the Operator Name can be
listed more than once under one job description but on the report I only want
to show the operator name once no matter how many times he is under that one
job description. Is this possible?


The first thing to try is setting the operator text box's
HideDuplicates property. If that doesn't do what you want,
post back with more details about what was wrong with it
along with more infomation about your report's design
(sections, grouping, where the important text box's are
located.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top