Hi I have started using Access for 2 weeks and appreciate if someone can offer helps on my problem below.
Say, I have a table as below:
1. All the records are in numerics
2. The first three columns (Date, Time, Results) are given
3. The fourth column (New) is the column that I want to create
4. The fourth column should look at the value in "Results" and find the first non-zero value (ie, 1 or -1) and the fill the records below with this non-zero value found for a particular day.
5. For a new date, repeat the process, ie, find the first non-zero value for that date, and fill the records with that value for the rest of that date.
Thanks in advance for any help.
Date Time Results New 20101001 1000 20101001 1100 20101001 1200 1 1 20101001 1300 1 20101001 1400 -1 1 20101001 1500 -1 1 20101002 1000 20101002 1100 20101002 1200 20101002 1300 -1 -1 20101002 1400 1 -1 20101002 1500 -1 20101002 1600 1 -1