User Profile

Collapse

Profile Sidebar

Collapse
cliffs
cliffs
Last Activity: May 25 '14, 04:58 AM
Joined: Feb 4 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cliffs
    replied to first highest / lowest before decrease/increase in high / low nos
    in Access
    Hi, thanks for your help, Actually, I want the the following result, but I get the wrong result while running the module :


    Code:
    sr.No. zonetype  result     vba result 
                 expected   
  1        1       1130     1136
  2        2       1147     1137
  3        2       1147     1147
  4        2       1149     1147
  5        1       1127     1147
  6        1
    ...
    See more | Go to post
    Last edited by zmbd; Apr 20 '14, 07:19 PM. Reason: [z{placed code tags on for romated table}]

      Leave a comment:

    • cliffs
      started a topic first highest / lowest before decrease/increase in high / low nos
      in Access

      first highest / lowest before decrease/increase in high / low nos

      I have the following the data in access 2003 database.

      Code:
       sr No.  high    low        pline     dline   basetype   zonetype    
   1    1146     1142       1124      1126        1         1
   2    1136     1134       1128      1126        1         2
   3    1137     1130       1129      1125        1         2
   4    1147     1139       1131      1134        1         2
   5    1131     1128
      ...
      See more | Go to post
      Last edited by zmbd; Apr 20 '14, 04:40 PM. Reason: [z{please format code and tables using the [code/] formatting. See FAQ}]
      No activity results to display
      Show More
      Working...