Tabelbaseret formular med querybaserede data

Jeg kan ikke bruge en query til formularen, så kan jeg ikke oprette nye ordrer, har prøvet.

When you make a query of you sum then you are taking values from more than one record (group). So Access has no real way of telling which record you want to update. To enter new order or alter existing then you should use a separte form that that purpose. With an updatable query or table.

You could also try using Dsum in an unbound field.

I used dLookup and the query. So it works :)

terry> a 'svar' as usual ;)

thanks

Dlookup, that only gives one value, dont you want the sum?

.

In the query I calculate the sum of 3 fields and I use orderID = formula.orderID

And then I use a DLookup which gives me the sum for each of the 3 fields in the formula.