Locate Column with Value

[mrszw]

Hi, i have got a table with 12 columns (Jan to Dec). In the table, there will be a particular column (month) with values, while the rest are null.

How do i use VBA to locate the particular month where there is value?

I am currently using a form and combo box to select that particular month, but would like to automatically locate the month with values.

Would appreciate any help or insight

Thanks!

 

[RuralGuy]

You have committed SpreadSheet on this table. Have you considered normalizing this table first?

 

[mrszw]

Hi RuralGuy, could you advise on how do i normalize it?

i am wondering how do i use VBA to look through the rows/cols and locate the col/row with value? Something like looping through Range in excel VBA environment, not sure how to go about it in access through

 

[RuralGuy]

Crystal has a good article on Normalization. You will be forever struggling with this db until you normalize the data.

 

[RuralGuy]

Here's another article on normalization from Microsoft.