M
Middlemuir The Bear
Please help.
I have used the code from Duane Hookom to concatenate a list of raw
materials with percentage inclusion on. What I want to do is group the list
by percentages and I can't seem to get it right.
The code that I have used is:
Materials: Concatenate("SELECT Percentage & '% ' & Material FROM
[qryProduction Sheet] WHERE [Mix No] =" & [Mix No] & " ORDER BY [KG Per
Batch]DESC")
Displays >>> 22% Steam Rolled Barley, 12% Steam Rolled Oats, 12% Steam
Rolled Peas
What I want it to display >>> 100 - 20% Steam Rolled Barley, 19% - 5% Steam
Rolled Oats, Steam Rolled Peas
The Query that this statement is in uses the table Mixtures
Fields: Mix No, Mix Name.
[qryProduction Sheet]
Fields: [Mix No], [Material], [Kg Per Batch], [Percentage]
Please could someone steer me in the right direction?
Thank You
I have used the code from Duane Hookom to concatenate a list of raw
materials with percentage inclusion on. What I want to do is group the list
by percentages and I can't seem to get it right.
The code that I have used is:
Materials: Concatenate("SELECT Percentage & '% ' & Material FROM
[qryProduction Sheet] WHERE [Mix No] =" & [Mix No] & " ORDER BY [KG Per
Batch]DESC")
Displays >>> 22% Steam Rolled Barley, 12% Steam Rolled Oats, 12% Steam
Rolled Peas
What I want it to display >>> 100 - 20% Steam Rolled Barley, 19% - 5% Steam
Rolled Oats, Steam Rolled Peas
The Query that this statement is in uses the table Mixtures
Fields: Mix No, Mix Name.
[qryProduction Sheet]
Fields: [Mix No], [Material], [Kg Per Batch], [Percentage]
Please could someone steer me in the right direction?
Thank You