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 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...

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...