simple question on Filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a query that pulls records from multiple tables. In the
resultant report, I want to be able to eliminate a record if the record
before it has the identical data in three of the fields.

The help files were of minimal use, and I have spent about an hour trying to
find this on the community site... I give! Any help would be appreciated.

Thanks,

Jim Conrady
 
It is *much* better to eliminate the records from the source query than to
try to suppress records/sections in the report.

How about making a query that just contains those 3 fields. In the query
properties, set Unique Values property to Yes. (This adds the DISTINCT
predicate to the query.). Save.

Now make another query that includes this one and all the other tables you
need for your report. The result is deduplicated, and so the report will
give the records you want.

The alternative is to mess with the report's runtime properties PrintSection
and MoveLayout in the Format event of the Detail(?) section, but this is
less efficient and leads to unreliable page numbering and incorrect
pagination if you print only some of the records in the report.
 
Allen, thanks. I appreciate your time and will try not to waste it. I tried
your suggestion: got the original query built and saved, but then when I
constructed the second query I got the same answers. I have not played with
it a while and feel like I ought to keep working on it for a little while. I
will be back in touch when I achieve success (or whine for help again).

Thanks. Watch this space.
 
Back
Top