Sammentælling

Lav en forspørgsel i "designvisning", vælg ønskede tabellr, lav evt. joins og "træk" de felter ned, som du have med i forespørgslen.

Herefter højreklikker du på et af felterne og vælg "Totaler"

Brug "Grupper efter" på de felter du vil guppere på, og "Antal" på dem du vil tælle

Glem ovenstående det afviste du jo i http://www.eksperten.dk/spm/290043 da du spurgte om nøjagtigt det samme

Hvad var der iøvrigt galt med den løsning som terry gav dig ?

you can use the iif fucntion for this but it isnt very smart.

I am sure I have answered a VERY similar question quite recently!

OH, there it is! what is wrong with that answer bukse, you gave me the points for a right answer there?

Yes you did Terry :o)

http://www.eksperten.dk/spm/290043

From the same user ;-)

Ja men jeg er ikke god til at håndtere access koder. hvor skal jeg skrive løsningen

That all depends where you want to see the result. If you want to see it in a query then you have to make a query. If you want to see it on a form then you could still use a query and then base the form on the query. NOTE: You can NOT update calculated fields in a form, or a query for that matter!

Hvor/hvordan skal det skrives i en forespørgsel

almost as in http://www.eksperten.dk/spm/290043

If you send the dB to eksperten@santhell.dk then I will make an example for you. I need to know which fields and which tables!

did you get it working?