Search results

  1. N

    formula in a text box within a form

    Wondered if anyone could help me. I’ve been trying to put a formula in a text box within a form, with not much successes. :confused: What I want the formula to do is:- From the Date field in the form, if there no date entry’s then display a Blank, if there is only one date entered, I...
  2. N

    Select quier problem

    Can any body tell me why. When this select querie finds duplicate between the [CallLog].cCID and the [Client Addresses], CallLog It need to puts an "Unknown" record in as well. Could you let me know where I have gone wrong, with this formula. SELECT CallLog.cCID, CallLog.dDATE, CallLog.tTIME...
  3. N

    UPDATE From one table to another using WHERE

    Can anyone advise me on what the SQL syntax would be to update a record within one table with the data selected from another table… e.g. UPDATE TABLE1 (COL1) With the data from TABLE2 (COLa,) WHERE TABLE1 COL2 = TABLE2 (COLc,) or TABLE2 (COLb,) or TABLE2 (COLc,) Thank you Nigel Cross
Back
Top Bottom