Hi
so currently i have an access db and im using sql to extract data from all my tables and then performing manipulation..
however could i do it using an access query or such..
its a little complicated
basically i have 5 different tables that contain the information that i need to calculate a number
i need to perform a few if statements and few loops for all the entries present in a table..
i need to multiply two numbers depending on the results of the if statements and then publish all this somewhere along with the relevent elements of the loops that are currently being executed
is this possible?
thanks
Jonathan
so currently i have an access db and im using sql to extract data from all my tables and then performing manipulation..
however could i do it using an access query or such..
its a little complicated
basically i have 5 different tables that contain the information that i need to calculate a number
i need to perform a few if statements and few loops for all the entries present in a table..
i need to multiply two numbers depending on the results of the if statements and then publish all this somewhere along with the relevent elements of the loops that are currently being executed
is this possible?
thanks
Jonathan