dsum problems

[Roy]

i have try to make a dsum in my query but i got a problem, i think!!
Allen Browne sugest "=DSum("quantity", "Table1", "code <= " &

)"
but, the field "code" is noy unique.

for a better explination:
a stock take is inserted all days into the database, that is all pallets in
stock at the moment.
i can have a number of pallets with the same products.
each pallet have a individual weight, sow i want to show the pallets i need
to meat todays order.

i hope u understand

if its easier to do in a text field in a tabular form, i will, else i have
to sort this issue in the query

thank u

 

[Klatuu]

Roy,

This is confusing. What do you mean the field "code" is not unique? There
cannot be more than one field in a table with the same name. More detail,
please