Populating two fields, but only display one field if there is a difference.

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,233
Office Version
  1. 365
Platform
  1. Windows
Hey Guys

I've recently started to use Access a lot more than I have previously and as such I'm trying to learn more about it and make some of my current processes in Excel more efficient by getting Access to do more of the donkey work.

I currently pull in data Tables from Access to Excel in a Macro and then use Excel to combine them using lookup formulas based on a part number.

I'm trying to get Access to get all this data together first before I pull it into Excel to avoid the slow down of the lookups, some of the worksheets will have 10's of thousands of rows.

So, I'm making a Query, part of which brings in two Fields from different Tables, "LTC" and "Previous LTC".

I always want to have a value in "LTC", "Previous LTC" should only show if it has a different value to "LTC"

So, in my Query I want to be able to say "If PreviousLTC is the same as LTC then don't display Previous LTC"

Is that possible?

Thanks for taking a look :)
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,223,886
Messages
6,175,190
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top