Search results

Dear Friends I have a table with RDate, Person and Rank fields. The table will be sorted by Rdate. Rdate Person Rank 10-Jan A 1 11-Jan B 3 12-Jan A 1 13-Jan A 2 14-Jan B 3 15-Jan C 2 16-Jan B 2 17-Jan C 2 18-Jan A 2 19-Jan B 2 20-Jan B 3 21-Jan A 3 22-Jan C 3 23-Jan C 4 I want to know when...

Dear Friend Thank you very much. It does work. Your prompt response help me a lot. Sai Kyaw Han :p

Dear Friends I have a table which contains Date and Cost. ADate Cost 1/4/2011 100500 1/27/2011 23000 1/29/2011 50000 2/3/2011 30000 Another Table have Exchange Rates EDate Rate 1/1/2011 700 1/14/2011 780 1/25/2011 760 2/2/2011 740 The cost in the first table is in Local...

Dear vbaInet You are correct. The table need to be sorted by ID or PDate.

Excellent!!! I have tried it. It works.

yes. it may need to be sorted, but not necessary.

Dear vbaInet My data is like your first statement. The patient category may change within a week or sometimes remaining the same for months. I want to retrieve the first date of change of patient category. Hope you could solve it. Best

Hi John thanks for your quick reply. If i group the category, i lost the incidence of first category "C". In this case I don't want to lose it. how should I solve it. Best NS

Dear friends I want to note down the record if it changes. Supposed I have a patient 101 and his category is as follow in respective date. PatientID Pdate Pcategory 101 1/1/2010 C 101 1/25/2010 C 101 2/10/2010 B 101 2/22/2010 C 101 3/2/2010 C 101 3/5/2010 A I want to retrieve records when...

Yes. It is right. Instead of default value, I want to add new record. Thanks in deed for your comment not to do it.

The subform I have created is based on the table. I had set the property of subform in "Continuous Forms". In this subform, I want to fill the default list.

Dear John thank you very much for your quick reply. I would like to clarify my question more. ID Food Unit Amount Regieme 1 Beer Bottle 1 1 2 Potato Pack 2 1 4 Beer Bottle 2 2 5 Potato Pack 3 2 6 BBQ Plate 3 2 7 Beer Bottle 5 3 8 Potato Pack 10 3 9 BBQ Plate 10 3 10 Water Bottle 5 3 If I...

Dear Friends Merry Christmas and Happy New Year! I am building a form with subform. I want to set different default value in the subform. The value will depend on a cell value in the form. For example: If the value of "Category" in the form is "1", the default value in the subform would be-...

Thank you for you response. When I open it, it ask me to fill ?? something. What should i fill. I have try 1 and 0 and some dates, but it doesn't work. Thanks in Advance Sai :)

Dear Friends :) I have 2 Dates; Starting Date and Ending Date. I would like to draw a Gant Chart based on these 2 dates. How should I create it? Best Sai

Dear Kafrin and friends I have tried with your codes. But it does not work. I think I should attached my file for you review. SSO means SubStockOut MSI means Main Stock In MSO means Main Stock Out The area I want to solve is at MSOIID(Main Stock Out Item ID) in SSOutItemSubform...

Dear Friends I have a form with a subform. A field in the subform looks up a value from a query. When I go to new record in the form, I want to filter the query. But when I am navigating the previous or old records, I want to leave the query unfiltered. Can someone tell me how to do it or...

Dear friends I have a form with a subform. In the subform it includes a combo field looking up for a datas. If the form goes to "New Record", I want the combo field look up query(A). If the form is navigating "Previous record", the combo field will look up another query(B). Can someone...

Dear Bob Thanks for your response. The LDOMth is the name of the text box in form "LDMonth". I try to declase the strQueryBal with "Dim StrQueryBal As String". In my new query which will created by this code, the "Period" will be added using the "LDMonth". After creating this new query...

Dea Ron Can you please check the code with my attached file? Thanks in advance