Search results

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...

Yeah, welcome to this great forum. I never had a formal coaching in Ms Access but through this forum I've met many great teachers. Cheers.

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

Hi GrameG, how did you add the code? Hope you can share. TQ

Thansk JANR. That's was very useful.

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...

using vba Hi, thanks for your reply. I do agree with you. That was the first function I created. Still learning. :confused: Any suggestion on vba?:rolleyes:

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...

hiding data Hi Rabbie, Thanks for your prompt reply. Actually I wanted to use the query to create a report. The report will only shown non-blank column including it's header. Can this be done? Thanks.

hiding empty column Hi KTJ_SBS, I wanted to do the same thing like this. Have you got any solution? Hope you can share. thanks.

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...

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

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.

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...

range Thanks for the advice. I will try that.

range Hi Uncle Gizmo, Thanks for your advice. I went through some post about running sum, but so far I can't found something like I need. I need a function that can calculate range before sum the result. For example: No, Data A, 195 B, 198 C, 196 D, 194 I need a function that can create a...

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...

statistic Hi, i'm also looking for that.. anyone has the answer?