Search results

  1. A

    records sorting

    I made a form as per attached snapshot where the record can be arranged by pressing button up or down. The arrangement of record is base on value in "sort" field which is automatically generated by VB and can be altered manually. What I want to do next is to automatically change the value in...
  2. A

    SPC database

    Hi, I'm creating a database for variable Statistical Process Control (SPC). Looking forward for any comments for improvement. Checkout at freeSPCaccess Cheers :D
  3. A

    Calculating query

    Hi, I have table like below x; y; z -1.99811696; 0.129995; 4 I want to make a query which calculate the running sum of (x + y) until z value runningsumx -1.199811696 -1.069816403 -0.939821111 -0.809825819 -0.679830526 -0.549835234 -0.419839941 -0.289844649 .... 4.0000000 Please help...
  4. A

    Creating Function to re-arrange field

    Anyone has tried this? I have a table like below: I want to create a query to rearrange the field like below: I managed to do that using below function. "ChooseLike" is 1 for No1, 2 for No2 and so on...
  5. A

    Hide unwanted data dan auto arrange

    Hi all, I have a table like below Item ; D1 ; D2 ; D3 ; D4 ; D5 ; ....., D20 X ; X1 ; X2 ; X3 ; X4 ; X5 ; ....., X20 Y ; Y1 ; Y2 ; Y3 ; Y4 ; Y5 ; ....., Y20 Z ; Z1 ; Z2 ; Z3 ; Z4 ; Z5 ; ....., Z20 These data will be displayed in 2 reports. Report A will show all data from D1 to...
  6. A

    make table query with primary key

    Hi, Anyone has the idea of creating primary key in a table using make table query? Thanks.:confused:
  7. A

    deactivate notification

    Dear all, I create a make table query. But every time I run the query, the notification will prompt out "are you sure....". Is there any way to disable this notification? Tq.
  8. A

    Ggrouping and do calculation on number of records

    Hi all, I tried to make a query that can do calculation (sum/count/avg/etc) on certain number of consecutive record. e.g. Time; Value 1; 5 2; 3 3; 4 5; 2 7; 5 11; 8 20; 5 22; 3 25; 1 Let say i want to sum each 3 consecutive records Time group; Sum A; 12 B; 15 C; 9 Any function can be use for...
  9. A

    moving range

    Hi all, I'm new in this forum and can be considered as beginner in Ms Access. I tried to make a SPC database and currently stuck at calculating the data range for moving range graph. The question is, how to calculate range between 2 consecutive data and then sum it. For example: A, 195 B, 198...
Top Bottom