There is no such thing as "contiguous records" in an Access table. Records in a table are like marbles in a box, there is no order.
You would need to provide some field value that determines how the records are grouped. Your other option is to use Excel which doesn't require uniqueness or sequences.
Duane Hookom MVP
MS Access MVP
----------------------------------------
> From: ciro.carbone@gmail.com
>
> Hi all.
>
> I do not have any success to try to solve this problem...
> I have a simple table containing 10 records. Each record contains a decimal value. I would like to average these values in a group of 10 contiguous records. For example:
>
> Value
> 5
> 10
> 2
> 7
> 23 ----> 9,4
> 7
> 33
> 67
> 6
> 1 ----> 22,8
>
> ...so my query result will consist of 2 records like below:
>
> Results
> 9,4
> 22,8
>
> Any tip will be appreciated.
>
> Many thanks
> Ciro
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar