 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / April 2008Display non-matching data in a report and don't display matching 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> I suggest you do this in the query that is the record source for the report.  SignatureDave Hargis, Microsoft Access MVP > Hello, Pros, > [quoted text clipped - 15 lines] > FIELD2 <DATA> FIELD2 <DATA> > FIELD3 <DATA> FIELD3 <DATA> Excuse me, but you didn't give me any advice at all; no help, no solution. > I suggest you do this in the query that is the record source for the report. > [quoted text clipped - 17 lines] > > FIELD2 <DATA> FIELD2 <DATA> > > FIELD3 <DATA> FIELD3 <DATA> 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. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Excuse me, but you didn't give me any advice at all; no help, no solution. > [quoted text clipped - 27 lines] >> > FIELD2 <DATA> FIELD2 <DATA> >> > FIELD3 <DATA> FIELD3 <DATA> 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. SignatureDave Hargis, Microsoft Access MVP > Excuse me, but you didn't give me any advice at all; no help, no solution. > [quoted text clipped - 19 lines] > > > FIELD2 <DATA> FIELD2 <DATA> > > > FIELD3 <DATA> FIELD3 <DATA> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.