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

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,227
Office Version
  1. 2013
  2. 2010
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

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

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