User Profile

Collapse

Profile Sidebar

Collapse
Rene Schepers
Rene Schepers
Last Activity: Aug 14 '12, 03:16 PM
Joined: Aug 11 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Rene Schepers
    replied to Select / Dlookup
    in Access
    Many thanks for your quick reply and assistance

    OK I have been programming with access for a good while and try to create more to my job specific databases and features.

    I just read the links you posted which are clear to me but not any contribution to a solution

    Let me show a small part of my table to clarify

    Tablename: Fuelbook

    ID Date plantno meter Prevmeter mileage liter Prevliter...
    See more | Go to post

      Leave a comment:

    • Rene Schepers
      started a topic Select / Dlookup
      in Access

      Select / Dlookup

      Dear Bytes Users

      I have created a database for fuel consumption for various vehicles. By entering the date, plantno, mileage_reading and liter. I managed to get the previous mileage_reading via a select statement in query:
      - created a query from a table fuelbook and made an alias fuelbook1
      - created a new field

      Prevmeter: (Select max(meter) from fuelbook Where meter < fuelbook1.[meter] and plantno...
      See more | Go to post
      No activity results to display
      Show More
      Working...