Jennifer, here's one that I constructed for my purposes.  It may work for you.  Sometimes when I get double entries, it's because the field names in the subreport are repeated (unnecessarily) in the main report.

Christine

Christine Droll
Collections Database Administrator

The Nelson-Atkins Museum of Art
4525 Oak Street | Kansas City, MO 64111
p 816.751.1333 | f 816.751.0499
[log in to unmask]





From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jennifer Day
Sent: Wednesday, June 18, 2014 7:20 PM
To: [log in to unmask]
Subject: Include a particular status flag in a report?

Hi,

I need to include a certain status flag in a report. I've made a subreport for the status flag and inserted it in the main report, but I'm doing something wrong. When I run my report, it comes back with duplicate reports for objects based on the number of status flags associated with each object (if it has two flags associated with it, I get two results for the record. If there are three, I get three back. Etc.) How can I make jus this one status flag appear on my report (without provoking duplicates)? Do I need to include a formula somewhere? Do I need to include something as a group? (This isn't a matter of filtering only for records with the desired flag at the query stage-I've got a large package to run this report on and some of the records have this flag, while others don't. But I need the records that have it to display that fact in the report.) Any hints would be most welcome.

Thanks!
Jennifer

Jennifer Day
Registrar, Indian Arts Research Center
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504
Phone: 505-954-7205
Fax: 505-54-7207
[log in to unmask]<mailto:[log in to unmask]>

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.