Ladies and Gentlemen,
I am fairly new to access. Mostly, I have used it to combine values and it was way too long ago.
I am working on a report, that deals with at least 12k to 15k lines, which I would like to have your opinion about.
So basically, this report contains following excel files:
- Raw Data Sheet
- Raw Data Sheet for Exceptional Rules
- Template with bunch of IF Rules
So what I have before is that, I have manually run everything, vlookuped it, combined data and somehow, I came to my report.
Now, with more and more lines of data getting added, its just getting unbearable. So now, I am thinking, if Access could help me with that.
Following questions are raised:
- Can I integrate those "IF" rules in Access?
- Can I make sequences to combine values and datas in Access to produce a finished report?
This are the examples of "IF" rules I am using in my Excel Template:
=IF(A2="T024";"SNP";IF(A2="T047";"SNP";IF(A2="T059 ";"SNP";IF(A2="T060";"SNP";IF(A2="T064";"SNP";IF(A 2="P004";"SNP";IF(A2="P008";"SNP";IF(A2="P009";"SN P";IF(A2="P017";"SNP";IF(A2="P019";"SNP";IF(A2="P0 40";"SNP";IF(A2="P042";"SNP";IF(A2="T086";"CSDM";I F(A2="T087";"CSDM";IF(A2="P021";"CSDM";IF(A2="P022 ";"CSDM";IF(A2="P025";"CSDM";IF(A2="P030";"CSDM";I F(A2="P031";"CSDM";IF(A2="P034";"CSDM";IF(A2="P035 ";"CSDM";IF(A2="P036";"CSDM";"RULE"))))))))))))))) )))))))
and
=IF(A2="T023"; IF(H2="MFG";"PPDS";IF(H2="Toll";"PPDS";"SNP")))
Every help and hints are very much appreciated.
Kind regards
Timothy