Search results

Dear missinglinq Thank you for your reply with patience. It is fine to go with your previous expression. Best

Dear Crake I mean the expression in my post is fine. It is OK. I just want to change the date in the expression from a form control. I don't want to change it by opening the query in the design view. Thanks

Dear Friends I have a query. If the [Date1] is before a particular date, I want to categorize it "Old", otherwise "New" in [NewOld] column of a query. I use the following expression which I got it from one of the friend in this forum. It is OK to run it. NewOld...

Dear Missinglinq Thank for your solution. It works and I can go with it.:) I also accept your logic. If it does not make you busy, Can I validate it with the immediate previous record? (Just for fine tunning and curiousity.):D Happy Chinese New Year

Dear Frineds I am refreshing my post. I'm afraid you forgot it. Best

Dear Friends I have a Travel plan table. It has "DepartureDate", "ArrivalDate" and "Destination". The "DepartureDate" of next destination should not smaller than "ArrivalDate" of previous "Destination". It can be equal to "ArrivalDate" of previous one. How to do validation for this case...

dEAR RainLover Thanks for your comment. I have correct it. It works.

Thanks for your interest. Among these 3 reports, "PartI", "DSAsubreport" and "PartIIsubreport". "PartI" is the main and the others are subreports. If you check the subreports, I tried to find the sum of some varriable which does not work. I have reattached the file which I have modified some...

Among these 3 reports, "PartI", "DSAsubreport" and "PartIIsubreport". "PartI" is the main and the others are subreports. If you check the subreports, I tried to find the sum of some varriable which does not work. Thanks

Dear Friends I am facing proble with Calculation (sum) in report. Please check my attached file. I want to run sum of some fields in the report. Thanks in advance

Dear DCrake Thank you. It works. In the second part, I want to clear the text that I have enter then get the focus on it. Can you please help me again? Best

Dear Friends I have a field which need 3 characters. The first charactor can be "A" or "B" or "C" or "D". (No blank) The Second charactoer can be "A" or "B" or "C" or blank. The Third charactoer can be "A" or "B" or "C" or blank. How should I do it? I prefer more in input mask.

Dear Mike Thank you. It works. NS

Dear Friends I have a table with the column named, "CODE", "SDATE". If the query, I will calculate a field named "CATEGORY". My conditions are 1. If the "SDATE" is before 1/1/2008, I want to put "Old" in the "CATEGORY" column. Otherwise "New". 2. In the "CODE", if the second character of the...

Dear Friends and Mike375 :D My string is already converted to Upper case. I try with the function of Mike375. It works. Thanks all and Mike for your help.

Dear Friends I have a column with string. I want to find the string containing specific character. For example if the string have D, H, O and R, the result in Yes/No column will show Yes. Otherwise No. Topics Yes/No ABCEHOY NO ABCDEHOR YES BCDGHMOR YES...

Dear Friends (High Tech Coach and John Big Booty):D Thanks for you quick resonse. Both of yours work. Best

Dear Friends In my Query, I have a Date Column. In this date column I want to put a crieteria in. The criteria is Dates between Today and 6 months before. I try to put the following one. But it does not work. Between #[Date()-180]# and #[Date()]# Please help me. Best:D

Dear Ziggy1 Thank you very much. It is exactly what I want to do. I wish I could do like you! Happy new year.:)

Dear friend I have to prepare the report periodically. Usually they are monthly, quarterly, 6 monthly and yearly. I usually have to change the "Period" column with the following formatting expressions. Now, instead of changing the formatting manually, I want to go it through a Form. Will it be...