User Profile

Collapse

Profile Sidebar

Collapse
loki419
loki419
Last Activity: Dec 29 '06, 10:46 PM
Joined: Dec 28 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • loki419
    started a topic Compare Fields across records
    in Access

    Compare Fields across records

    Is there a method using MS Access that I can compare a field on one record to the same field in a subsequent record.

    For example, if I have a query that has three fields and four rows as follows

    Cost_Centre, Account, Month
    110 2200 Jan
    110 2200 Jan
    101 2200 Feb
    101 2200 Feb

    Is it possible to...
    See more | Go to post
    • loki419
      started a topic Running count in Access query
      in Access

      Running count in Access query

      I have a simple select query that produces results similar to this

      LOCATION FUNCTION
      001 1111
      001 1111
      100 1111
      100 1111
      100 1121
      100 1131
      200 1111
      200 1111
      201 1111

      I would like to have a new field...
      See more | Go to post
      No activity results to display
      Show More
      Working...