B
Bonnie
Hi there! Using A02 on XP. Not a programmer but working
with event procedures now and loving it. I receive fund
return data from 2 sources that must be compared and
source B must be corrected to agree with source A. Each
file is imported to Access tables and looks like this:
tSourceA
Fund Since CalYTD 1Yr 3Yr
Equity 10/01/99 2.10% -3.45% 1.55%
Bond 05/31/88 1.98% -0.38% 2.05%
MMkt 04/01/00 1.85% 0.85% 1.74%
tSourceB
Fund Since CalYTD 1Yr 3Yr
Equity 10/01/99 2.15% -3.35% 1.55%
Bond 05/31/88 2.02% -0.60% 2.05%
MMkt 04/01/00 1.85% 0.85% 1.74%
On Equity/CalYTD, I must compare the 2.10% and 2.15% and
retain the 2.10%. Same for the other interest rates. I
also need to record/report which ones had to be changed if
at all possible. That may be a separate project.
Is this an inner join update query candidate? Would really
appreciate a better brain on this so I can get a
jumpstart. Thanks in advance for any help or advice!
with event procedures now and loving it. I receive fund
return data from 2 sources that must be compared and
source B must be corrected to agree with source A. Each
file is imported to Access tables and looks like this:
tSourceA
Fund Since CalYTD 1Yr 3Yr
Equity 10/01/99 2.10% -3.45% 1.55%
Bond 05/31/88 1.98% -0.38% 2.05%
MMkt 04/01/00 1.85% 0.85% 1.74%
tSourceB
Fund Since CalYTD 1Yr 3Yr
Equity 10/01/99 2.15% -3.35% 1.55%
Bond 05/31/88 2.02% -0.60% 2.05%
MMkt 04/01/00 1.85% 0.85% 1.74%
On Equity/CalYTD, I must compare the 2.10% and 2.15% and
retain the 2.10%. Same for the other interest rates. I
also need to record/report which ones had to be changed if
at all possible. That may be a separate project.
Is this an inner join update query candidate? Would really
appreciate a better brain on this so I can get a
jumpstart. Thanks in advance for any help or advice!