I have a table in which besides having other fields, there is one filed as Item code (Text) and another field as NumberOfTimes (numeric)
Item Code| NumberOfTimes| LotSize
x | 2 | 100
y | 3 | 50
z | 1 | 10
So I want to repeat this record as :
Item Code | LotSize
x |100
x | 100
y | 50
y | 50
y | 50
z | 10
I was using following SQL statement, which was giving me perfect result, however, all of sudden, this query started giving me following error : Data Type mismatch in Criteria Expression I am just unable to figure out the reason, as I've not changed any field type!
SQL :
Expand|Select|Wrap|Line Numbers
- SELECT MfgPlan.*
- FROM MfgPlan INNER JOIN MaxBatchNumbers ON MaxBatchNumbers.BatchNumber<= MfgPlan.NoOfTimes
- ORDER BY MfgPlan.ItemCode;