Changes in Text

[Ozborn]

I started using Access about a week ago in hopes that I could simplify a report that I do.



Basically, I receive data from a client that consists of names, addresses and phone numbers. My company contacts these individuals and the information is updated. The report that I do tracks any changes to the information.

I currently complete this report in Excel by matching the ID number of each original record with the ID of the each contacted record.

For example, column “H” would include the changed first name of the contact and column “I” would include the original first name. Column “J” would include either “YES” if a change has been made or nothing if the information is the same.






In Access, I have combined the two tables and created columns titled “Change” that I can export to Excel where I can add the formulas. This works but is it possible to include a formula or expression in the “Change” field that would save me this step?

[pbaldy]

In a textbox:

=IIf(Changed = Original, "", "Yes")

[CJ_London]

yes, pretty much the same

SELECT ID, Changed, Original, iif(Changed=Original,"","Yes") AS Change
FROM myTable

But I would argue this is not the best way of doing things. It is the Excel way and Access works in a differently. For example, no need to combine tables into one. What is the best way really depends on what data you have, how it is stored etc

[Ozborn]

Thanks,

I’ve tried variations of =IIF and I must be doing something else wrong because I end up with nothing when I know there are changes.

@Ajax
I use a query to compare the clients original data with our contacted data (both .csv files). I send them back only the contacted records and indicate if there has been a change (again .csv).

My client needs the original and the changed data so that they can see what it was before and after contact.
I figured out how to do a couple of other things with Access and decided to try an simplify this report with it. What I did with Access was much faster than sorting through 100,000 records by color in Excel.

I appreciate the help but this might be over my head right now. For the time being I’ll just continue to fumble around with this until I get a better grasp of what can be done with Access.

Thanks again.