Search results

  1. S

    Copy unbound textbox value into 2nd table

    Dear all, My question is to know how to copy a unbound textbox named balance " =nz([Total Deposits])-nz([Total Withdrawals]) " which is located in my form control and paste into another master table once the field get updated? Any trick will do? Thanks in advance.... Regards, YEONG
  2. S

    Cumulative field/column

    would like to implement in the grafic a cumulative function in one collumn like for one field "value" : value + (value+1) + (value+2) + .....+ (value+n) where he sums the value and the folowing one until the end.... How can I do this? can you help me on this simple question Thanks in...
  3. S

    Failed to power off when trigged by Powerchute

    Hi, there. This has been bothering me a lot since 2 weeks ago. Does anyone has ever encountered this problem ; My HP E50 server has been running well with APC powerchute progam and it can power off and power on accordingly . But somehow someday it stoped powering off even though most of the...
  4. S

    window to show table list

    Hi, there. I'd like to enquire is there a way to call upon a something like dropdown floating window showing table's particular fields when i execute the report. THe report i call will contain parameter like "Enter product". The floating window aims to serve the parameter prompt purpose. Ur...
  5. S

    Question on crosstab

    Dear all, Just wonder is it workable that I insert another column into crosstab to calculate percentage formula instead of the sum ? My scenario is: Category total B-100ml B-500ml B-1l Cap28mm Cap33m bottle 100 50 50 0 cap 50 10 40 The above is created from the crosstab wizard that can give...
  6. S

    Showing "0" value but not formulated query

    Len(Nz([MyDateField],"")) What a rare command given! Guy, could u pls explain in detail how do i use the above statement, i do know what LEN is but dono the Nz, pls elaborate a bit as well as the criterion > 0 or <> "0" I am just a new learner .............Thanks you
  7. S

    Showing "0" value but not formulated query

    Hi, all my dear friends. Long time didn't email u for helps. Hope u won't mind answering me once again. This time around i got a request if this is feasible or not...It happens that I used Access query to change the 6 digit string field to date format by using formula, like this ShipDate...
Back
Top Bottom