Trouble getting correct data in text boxes

[svjensen]

I have a simple table consisting of four fields:
uid
grad (rank)
aarstal (year)
antal (number)

(see example here: http://www.vinther-jensen.dk/access/test_1aDB.mdb)

I would like to present the data in a grid on the form as shown in the example with grad (rank) down and aarstal (year) across. The textboxes obviously should contain the sum of the intersection between grad and aarstal.
How should I go about this?

/Soren

 

[svjensen]

I worked out a solution by entering

=DLookUp("sum([normering])";"[1aDB]";"[grad] = 'M331' and [aarstal] = 2010")

as the textbox's ControlElementSource

/Soren

 

[JamesMcS]

A subform with a crosstab query as you've described it would also work fine.