M
Maqza via AccessMonster.com
Hi!
I already converted data from Excel to MSACCESS ,but the problem is formula,
please help me how to write diff % formula in SQL
Date Alpha priceDiff% Beta Price Diff% Gama Price Diff%
28-Apr-05 11,543.90 96.1500 96.79880
05-May-05 11,259.89 -2.46% 93.5432 -2.71% 95.35300 -1.49%
12-May-05 11,816.37 4.94% 99.0128 5.85% 102.10920 7.09%
19-May-05 12,369.04 4.68% 103.4625 4.49% 107.89220 5.66%
26-May-05 12,477.61 0.88% 101.0567 -2.33% 105.53020 -2.19%
02-Jun-05 12,488.77 0.09% 100.9504 -0.11% 105.84220 0.30%
09-Jun-05 12,989.26 4.01% 104.3117 3.33% 110.04090 3.97%
please help me in this regard
I already converted data from Excel to MSACCESS ,but the problem is formula,
please help me how to write diff % formula in SQL
Date Alpha priceDiff% Beta Price Diff% Gama Price Diff%
28-Apr-05 11,543.90 96.1500 96.79880
05-May-05 11,259.89 -2.46% 93.5432 -2.71% 95.35300 -1.49%
12-May-05 11,816.37 4.94% 99.0128 5.85% 102.10920 7.09%
19-May-05 12,369.04 4.68% 103.4625 4.49% 107.89220 5.66%
26-May-05 12,477.61 0.88% 101.0567 -2.33% 105.53020 -2.19%
02-Jun-05 12,488.77 0.09% 100.9504 -0.11% 105.84220 0.30%
09-Jun-05 12,989.26 4.01% 104.3117 3.33% 110.04090 3.97%
please help me in this regard