Recent content by Nancyade

Below is the replace query I've writen but i need to replace more than one address,how do i go about replacing more than one address in one query? Expr1: Replace([ Address],"12 THE SLADE PLUMSTEAD SE18 2NB"," 12 THE SLADE PLUMSTEAD LONDON SE18 2NB")

can anyone help to convert the below access if statement to sql? Response Time: IIf([Referral Acknowledged ]="0","Yes on Target",IIf([Referral Acknowledged ]="1","Yes on Target",IIf([Referral Acknowledged ]="2","Yes on Target",IIf([Referral Acknowledged ]="3","Yes on Target",IIf([Referral...

I need help to convert the below excel if statement to access. =IF(AND(H6>M6),H6-M6) I did the convertion but it is not working properly, please find below my convertion Awaiting Outcome: IIf([Number New referrals]>[Total Outcome],[Number new referrals]-[Total Outcome])

I have set up a delete and append query to eliminate duplicate client I'd numbers using the primary key and this works fine if am running the report for just one month. However if I want to run the report for three months the report and if there is a transaction with a client for the three...