return not the desire number of rows..

[Goh]

i have input 10 rows of data...and when i query (select) all the rows i only got the second set of 5 rows!... how come the first set of 5 rows are not shown?

[mendhak]

What's the QUERY

[Goh]

 SELECT Purchase_Requisition_T.PR_NO,Account_Name_Code,Authority_Name,Currency,Project_Name_Code, Date_Raise,Date_Require,Supplier,Purpose,YearR,Total_Cost_In_SGD,Description,Unit_Cost,Qty " & _
            " FROM Purchase_Requisition_T" & _
            " JOIN Account_Charge_To_T ON Purchase_Requisition_T.Account_Charge_To_ID = Account_Charge_To_T.Account_Charge_To_ID" & _
            " JOIN Authority_Name_T ON Purchase_Requisition_T.Authority_Name_ID = Authority_Name_T.Authority_Name_ID" & _
            " JOIN Currency_T ON Purchase_Requisition_T.Currency_ID = Currency_T.Currency_ID" & _
            " JOIN Project_T ON Purchase_Requisition_T.Project_ID = Project_T.Project_ID" & _
            " JOIN DataBase_T ON DataBase_T.PR_ID = Purchase_Requisition_T.PR_ID " & _
            " WHERE Purchase_Requisition_T.Status_ID = ' " & Status & " ' And Purchase_Requisition_T.User_Name_ID = ' " & UserName &

[Goh]

there are 5 rows of PR_NO 1 and another 5 rows of PR_NO 2...i only got the 5 rows of PR_NO 2...

[mendhak]

Originally posted by Goh

 
            " WHERE Purchase_Requisition_T.Status_ID = ' " & Status & " ' And Purchase_Requisition_T.User_Name_ID = ' " & UserName &

Gosh... you think it might be this?

Are the records present with different values for User_Name_ID and Status_ID?

[Goh]

yes i am sure all the records have that value....i try out in sql query for the number but still got 5 rows..

[leinad31]

Originally posted by Goh

 SELECT Purchase_Requisition_T.PR_NO,Account_Name_Code,Authority_Name,Currency,Project_Name_Code, Date_Raise,Date_Require,Supplier,Purpose,YearR,Total_Cost_In_SGD,Description,Unit_Cost,Qty " & _
            " FROM Purchase_Requisition_T" & _
            " JOIN Account_Charge_To_T ON Purchase_Requisition_T.Account_Charge_To_ID = Account_Charge_To_T.Account_Charge_To_ID" & _
            " JOIN Authority_Name_T ON Purchase_Requisition_T.Authority_Name_ID = Authority_Name_T.Authority_Name_ID" & _
            " JOIN Currency_T ON Purchase_Requisition_T.Currency_ID = Currency_T.Currency_ID" & _
            " JOIN Project_T ON Purchase_Requisition_T.Project_ID = Project_T.Project_ID" & _
            " JOIN DataBase_T ON DataBase_T.PR_ID = Purchase_Requisition_T.PR_ID " & _
            " WHERE Purchase_Requisition_T.Status_ID = ' " & Status & " ' And Purchase_Requisition_T.User_Name_ID = ' " & UserName &

Did you mispost again, or did you actually miss the apostrophe after UserName at the very end?

[Goh]

oppos sorrie again i mispost...kakakak

[leinad31]

Ok so what's the query?

By the way, any chance that some of the fields you used for the ON conditions have NULL values?

[mendhak]

kakakak

[Goh]

wua la igot null values..now trying to fill it up with a string...

[vbNeo]

Originally posted by mendhak

I bet it's lauging! I'm chatting with a mexican who 'text-laughs' with 'jajaja' - reaaalllyyyy strange =).

Totally unrelated to the subject - Cheers