Recent content by Nigel Cross

Thanks for having a look at my post. The date field is in a sub-form, so it’s been sorted by query. I only want this formula to apply to this sub-form and all the dates it has listed in it. Does this make scene.

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

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

Thanks Hitec, this worked just great.:)

Thanks HiTec I give it a try. Thank for your in put.

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

Appreciate help with the following. Trying to link a single database record to multiple Telephone numbers i.e Home Phone No and Work Phone No and Mobile Phone No. From a table called CLIENT ADDRESSES. Then I want it to put the corresponding ID NUMBER from the (CLIENT ADDRESSES table), into...

Did you manage to get your database to recognise the UK caller info. If so how did you go about it. I have a database that I wish to be able to recognise the UK caller info from my modem, which I know excepts UK called ID info. Then store the Date, Time, and Number of the call Thanks...