lookforsmt
Registered User.
- Local time
- Today, 05:54
- Joined
- Dec 26, 2011
- Messages
- 672
HI!
i have two tables, temp_tbl_SubProduct_Out and tblCount.
I need to achieve additional rows based on the field Qty_Count. For e.g. if the Qty_Count is 3, then it should repeat 3 rows after running the query.
I have the below query which gives me the result with an additional row, so in the above e.g. it gives me 4 instead of 3.
1) How can i get the same count as mentioned in the field Qty_Count (refer snapshot pls)
2) If i have to do this by writing vba code function. can anyone help me with that.
i have two tables, temp_tbl_SubProduct_Out and tblCount.
I need to achieve additional rows based on the field Qty_Count. For e.g. if the Qty_Count is 3, then it should repeat 3 rows after running the query.
I have the below query which gives me the result with an additional row, so in the above e.g. it gives me 4 instead of 3.
SELECT temp_tbl_SubProduct_Out.*
FROM temp_tbl_SubProduct_Out INNER JOIN tblCount ON tblCount.CountID <= temp_tbl_SubProduct_Out.Qty_Count;
1) How can i get the same count as mentioned in the field Qty_Count (refer snapshot pls)
2) If i have to do this by writing vba code function. can anyone help me with that.