User Profile

Collapse

Profile Sidebar

Collapse
Tomas
Tomas
Last Activity: Mar 12 '07, 08:04 PM
Joined: Feb 27 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tomas
    replied to How to average 3 last records?
    in Access
    Here is my data:
    Query Name = Qry_priskaiciuo ta
    Field; Type; Index/Info
    Darbuot_ID; Numeric
    Laikotarp_ID; Date/Time
    Priskaiciuota_V ISO; Currency

    I need the Average of Priskaiciuota_V ISO by 3 last Laikotarp_ID records for Darbuot_ID.

    Code:
    Darbuot_ID	Laikotarp_ID	Priskaiciuota_VISO
3	              2007-01-01	1.200,00 Lt
3	              2007-02-01	1.133,33 Lt
3
    ...
    See more | Go to post

      Leave a comment:

    • Tomas
      started a topic How to average 3 last records?
      in Access

      How to average 3 last records?

      I'm creating MS Access database and I need to have in query an average of 3 last records.
      How to do it?
      Maybe here is some function or sql expresion?

      Thanks
      See more | Go to post
      No activity results to display
      Show More
      Working...