Validation of Data in a column.

[kbsudhir]

Hello,

I am want to validate the data in a table column as per the data in a corresponding column in teh same table.

Ex. I have a table with column "Frequency" of datatype Text.
And other 12column are in the name of the months. i.e. Jan, Feb etc of datatype "Yes/No" in checkbox format. Default value as false.

I have only 4 different values i.e. Yearly, Half Yearly, Quarterly And Monthly.

If the value is Yealy then I should able to change the value on Only "Jan" from False to True.

Similarly If the value is Yearly then I should able to change the value on Only "Jan" & "July" from False to True.

Same holds true for Quarterly changing the values only of March, June, Sep & Dec from false to true.

Can anyone guide me to do this would be great.

Thanks
Sudhir

 

[ColinEssex]

Your table is in the style of a speadsheet. You should not have 12 columns, one for each month. You should have a txtMonth column with each date in it vertically.

You need to read about normalisation of data. Once you have mastered this, you can validate with ease.

Col

 

[kbsudhir]

Colin can you refer some nice links for the normalization concept.

Thanks
Sudhir

 

[Rabbie]

Try looking in Access Help and Wikipedia. Then if you need more info try Googling for Normalization.

 

[ColinEssex]

Or use the search fascility on these forums

Col