Search results

Good Morning Sir, How can i increase the character from 255 to 1000 or more

Report Dear Sir, Good morning I have attached Access file and report sample in Excel. If you could help me to get that report it will be highly appreciated. In the Design register there is Preliminary drawings, Detailed drawings, Concept drawings included.

Mr.Arnelgp, Thank you for your help. Really really thank you. You are genius. I am a just starter. :):)

Re: Report Good Morning Sir, If you have time please help me to put total(Sum) for Status A + B +W + I + Open in the last coloum.I have attached access file.

Good Morning Sir, If you have time please help me to put total for Status A + B +W + I + Open in the last coloum.

Thank you very much for your help. I need one more coloum for open items (Under Review) and total in that report. One more question about document type that if there is lot of document type i should add manually in Criteria In ("MS","MT","PL","RD").

. Good Morning Sir, I have enclosed the file.

Good Morning, Please help me to get the Report in Access. I have attached Access file and Excel sample. I tried but i am getting with full data. But i need a status A, B, W, I each in count only.

Good Morning Mr. Arnelgp, Please help me to get the Report in Access. I have attached Access file and Excel sample. I tried but i am getting with full data. But i need a status A, B, W, I each in count only.

Thanks a lot Mr. Arnelgp. Really appreciate your help. It was very helpful.:).

Thanks a lot Mr. Arnelgp. It is working well. Now i have attached Excel sheet for Outgoing Correspondence. Please make it. Really thank you so much for your help. Attached Files File Type: xlsx Outgoing Letter Register.xlsx (32.0 KB, 0 views)

. Thanks a lot Mr. Arnelgp. It is working well. Now i have attached Excel sheet for Outgoing Correspondence. Please make it. Really thank you so much for your help.

Hi Sir, Thanks for your response. But still not working. I have attached Excel for your reference.

Thanks for your response. I tried it but couldn't succeed. Please can you put it in the attached file-Query -Incoming Correspondence-First formula in the place of No. of Days Remaining and second formula in the place of Open/Closed .

I need first formula in the attached file -Query-Incoming Correspondence-No. of Days Remaining and Second formula-Query-Incoming Correspondence-Open/Closed. Please help me to get this formula in the attached file

Hi Good morning, i need to convert the following Excel formula into MS access. First one =IF($J2="","",IF($L2<>"",IF(OR($K2=$L2,$M2>=7),"EXPIRED","RETURNED"),IF($K2-TODAY()>=1,$K2-TODAY(),"EXPIRED"))) second one =IF(J2="","",IF(L2="","Open","Closed")) J2 refers Received Date L2 refers...