Search results

dear all, i have the problem when using dcount in my query,anyone can help me?this is the situation. Table 1: Num 20080207 20080215 20080218 Table 2: Begin End 20080206 20080208 20080200 200802116 i want to make the query,and i want to add field "sumactive" using the...

dear bob, yeap,i have abc.txt file in my c drive..but it still an error. regards martell

dear bob, i'm already change the file name into abc.txt but the error message is still the same..any other way to solve my problem?thanks alot..u're so kind regards martell

dear bob larsson Dim rst As ADODB.Recordset Dim strFile As String Dim strInput As String Dim varSplit As Variant Dim intCount As Integer Set rst = New ADODB.Recordset ' CHANGE THE TABLE NAME HERE rst.Open "TextImportTest", CurrentProject.Connection...

dear all, i have a problem when i want to importing *.txt files into a new table..i have the *.txt's file format like the attachment. the question is, i want the result in the table,between field NO until field amount in one record my table fields is |No|PLU|Desc|QTY |FRAC...

the situation is i want the query automatically calculate the grade of the student score using the score table. thanks

thanks..it's works bro.....

thanks 4 the comment, it's works.but what if i want to add another value?i don't want to write a many code in my program,i just want to use the master criteria table.if i have a new grade criteria i dont need to write the code again.it's automatically calculate..anyone can help me?

dear all; i've a table #student like studentID score Sminth 88 samantha 76 Williamv 45 martell 78 and i also have a #grade table Grade Start end F 0 45 E 46 55 D 56 65 C 66 75 B 76 85...

Dear all i have a trouble to define a rank in query, i have a table named SALES like below region PRoduct qty jabar A 10 Jabar B 20 Jabar C 30 Jateng A 50 Jateng B 40 Jateng C 35 i want to give a result in my query like...