Hello ,
I wonder if it is posible in case the value in a query is null to assume by default the previous value. this is how the output of my query looks like :
so, the 2 blanks in record number 8687, would be filled with 4.03 and 3.88
and in record 9131 I would get the value 4.04
I ve been trying with dlookup, but perhaps that is not the right way
Any toughts ?
I wonder if it is posible in case the value in a query is null to assume by default the previous value. this is how the output of my query looks like :
id | jogoPla | pladataScrap | PinnacleW | marathonW | 1xbetW |
7594 | Genk - Club Bruges | 27/02/2020 02:30:50 | 4.03 | 3.94 | 3.90 |
7989 | Genk - Club Bruges | 27/02/2020 03:30:49 | 4.02 | 3.93 | 3.90 |
8403 | Genk - Club Bruges | 27/02/2020 04:30:50 | 4.03 | 3.94 | 3.88 |
8687 | Genk - Club Bruges | 27/02/2020 04:39:09 | 3.92 | ||
8847 | Genk - Club Bruges | 27/02/2020 05:30:50 | 4.04 | 3.90 | 3.90 |
9131 | Genk - Club Bruges | 27/02/2020 05:39:12 | 3.95 | 4.00 | |
9293 | Genk - Club Bruges | 27/02/2020 06:30:51 | 4.03 | 3.94 | 3.90 |
so, the 2 blanks in record number 8687, would be filled with 4.03 and 3.88
and in record 9131 I would get the value 4.04
Code:
SELECT tblTempGraf.id, tblTempGraf.jogoPla, tblTempGraf.pladataScrap, tblTempGraf.PinnacleW, tblTempGraf.marathonW, tblTempGraf.[1xbetW]
FROM tblTempGraf
WHERE (((tblTempGraf.jogoPla)="Genk - Club Bruges"))
ORDER BY tblTempGraf.pladataScrap;
I ve been trying with dlookup, but perhaps that is not the right way
Any toughts ?