Display non-matching data in a report and don't display matching d

[Dominick D.]

Hello, Pros,

Basically, listed below is a report that I'm doing. This is a small sample
of the report that will have over 400 fields, 200+ on the DB2 DATA side and
200+ on the SAP DATA side. It will show the field name, followed by the data,
as shown below. Now, what I'd like to do is, if data from the D2B DATA and
SAP DATA columns match, then DO NOT DISPLAY THE FIELD NAME OR THE DATA. The
report will only show the fields and data THAT DO NOT MATCH. I think this can
be done with a little programming, but I don't know VBA or VB. Can someone
help me out? I'd appreciate it.


SAP DB2 Data Comparison Report

DB2 DATA SAP DATA

Cust_Nam Wendy's Con_Legacy_Name2 McDonalds

FIELD2 <DATA> FIELD2 <DATA>
FIELD3 <DATA> FIELD3 <DATA>

 

[Klatuu]

I suggest you do this in the query that is the record source for the report.

 

[Dominick D.]

Excuse me, but you didn't give me any advice at all; no help, no solution.

 

[Douglas J. Steele]

Excuse me, but he did give you advice.

Dave's suggestion was that you write the query so that it only return those
rows that need to be displayed and use that query as the report's
RecordSource, rather than using a query that returns all rows and using VBA
to determine which rows to display and which to ignore.

Given you gave no details of what the tables involved look like, that's as
good advice as anyone can provide.

 

[Klatuu]

This is a volunteer site. All responses come from people who do not work for
Microsoft. We only try to support and promote Access.

Being rude wont help you much at all.

I did give you advise, but not a solution. How could I write a query for
you not knowing your data?

Let me state it again. It would be difficult or impossible to accomplish
what you want to do in the report. You should create a query or queries that
present the data the way you want it on the report and use the main query as
the report's record source.

Another way would be to write some recordset processing in VBA and add
records to a table that you could use as the report's record source. I
didn't mention that previously because you said you did not know much VB or
VBA.

So if these methods are beyond your capability, I suggest you hire a
professional who can either assist you are do it for you.