WHERE Clause for MS Query

[shdawson]

Hi,


Question about a WHERE clause with MS Query, please.

Have a worksheet going where I grab some fields and put them into a worksheet. From there, I do further on sheet calculations against that data. Need to make some cells either a zero (0) so I do not see them, per the TOOL/OPTIONS/VIEW checkbox for Zero Values, or conditionally format them as white, or something. Conditional Formating with a formula is a pain to manage with data changing.

What would be the nicest is to not bring that data into the worksheet through the said query. My logic qualifier is if another field equals something, do not bring that data in…but a zero (0).


So, the logic, generically is this….

IF TASK TYPE = “POR”, make INTIAL BUDGET 0

-or-

IF TASK TYPE = “POR”, don’t get INTIAL BUDGET.



So, in MS Query, can this type of functionality be achieved? Or, any better ideas?


Thank you very much……

 

[shdawson]

Achieved.

Inserted a new column on the worksheet, with the following formula.


=IF(K2="POR",0,U2)