Hello,
I am fairly new to programming and so far I've only been able to create a database using queries (the drag and drop a link kind, not SQL). I am trying to find the max value from a table and return the field header, and I think I need to create that via a module, which I was hoping to get some help with. For example, in the below table, I am trying to return the month where each client had the largest value. A would return Mar while B would return Feb. Is there an easy way to create a module for this? Ideally, the output of "Mar" & "Feb" can be in a newly created column in Table 1, or if I can create a 2nd table containing this information with Customer Name filled as well, that would work.
Thanks in advance for your help. I am just clueless when it comes to programming.
Table1:
Customer Name Jan Feb Mar A 1 2 3 B 4 5 0