Inspect Table and retund a Char. in Access

[bcarneyAEP]

Hi
I am converting an Excel spreadsheet to an Access DB. The Excel sheet has a formula that inspects a quantity of cell for "yes". If yes is found in any of the cells it places a yes in a single colunm (Excel code provided below). How can I do the same Lookup in an Access query?

Excel formula
=IF(OR(,K2="yes",L2="yes",M2="yes"),"X","")

Data lay out
Col1, Col2, Col3 New cell for reslults
Yes, Yes, Yes Retruns Yes in cell
Yes, No, Yes Returns Yes in cell
No, No, No Returns Null in cell

Thanks In advance

Brian

 

[John Big Booty]

Given that you are coming at this from an Excel back ground., one of the most difficult things you are going to have to do, is to re-learn the way you think about problems like this.

The first concept you need to get your head around is that of Data normalisation. This is key to good, and efficient database (DB) design.

The next thing is to think in terms of Records rather than Rows, and Fields instead of column.

So if we return to your initial question, in DB terms there is no need to add an additional field as you wish to do, as this would be in breach of the rules of data normalisation. What you would do is simply interrogate the data at the time it is required for display in either a Form or Report and determine if you need to display a Yes or No result.

As I've already said you may initially find this a rather difficult concept to understand, but stick with it and it will pay dividends in the end.