re dsum

R

Roy

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

Roy said:
i have try to make a dsum in my query but i got a problem, i think!!
Allen Browne sugest "=DSum("quantity", "Table1", "code <= " &
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[/QUOTE]
******************************************
message of yesterday

what i mean by code not being unique is that u can have:
Code     Description       Kilos
112121  Rump Steak     300
112121  Rump Steak     250
112121  Rump Steak     280
977234  Sirloin Steak    200
977234  Sirloin Steak    230
....
and what i what is this
Code     Description       Kilos    Kilos Ac
112121  Rump Steak     300      300
112121  Rump Steak     250      550
112121  Rump Steak     280      830
977234  Sirloin Steak    200     1030
977234  Sirloin Steak    230     1260

thank u
Click to expand...
 
Top