E
Eamonn
Hey,
I have an excel sheet linked into my access front end form which consists of
a lot of combo boxes to bring up a subform and a graphs and this all worked
fined until I added a further 20 or so columns to my excel sheet which are
basically sum if statements for live FX rates which feed into the excel sheet
via a bloomberg terminal. I have cut down my my exchange rate input to just 3
rates n 3 sum if statements and this has helped saving time ( or the time to
switch from design to form mode) is down to 20 odd seconds but I neeed to get
the other (20 odd) currencies all in.
I know that one should apply calcuations to data within Access but there is
no bloomberg add in So what ya all think??
-Eamonn
I have an excel sheet linked into my access front end form which consists of
a lot of combo boxes to bring up a subform and a graphs and this all worked
fined until I added a further 20 or so columns to my excel sheet which are
basically sum if statements for live FX rates which feed into the excel sheet
via a bloomberg terminal. I have cut down my my exchange rate input to just 3
rates n 3 sum if statements and this has helped saving time ( or the time to
switch from design to form mode) is down to 20 odd seconds but I neeed to get
the other (20 odd) currencies all in.
I know that one should apply calcuations to data within Access but there is
no bloomberg add in So what ya all think??
-Eamonn