Recent content by stef123

Wow guys, thanks for the respond, but you are way out of my league. I've tried just setting the controlsource to =[population]/[surface], also i've tried =iif(nz([surface],0) =0,null,[population]/[surface]). In both cases I'm asked to enter a parameter value. What do I need to do there?

No, I see what you mean, but the table that i've got is exactly the same as I put it in here. All the information in it is only shown once, so if country nr. 1 is next to nr.2, the table only shows 1 connected to 2, and not :1 connected to 2 and 2 conected to 1. Is there still a possibility to...

Hi there, I can't seem to figure out how to add a new field in my report. I have an existing report about cities, it's population and the country which it is in.It's alphabetically ranked on the name of the cities. What I need to do now is add an extra field with the population of the country...

Hi there, I just can't figure out how to solve my next problem. What I need to do is to make a query showing all the country's next to germany(nr.5) with their capitals. There are three tables which I can use, nr.1 showing the country_id's with their "neighbour country's", nr.2 showing the name...

I have three tables; table 1 is called 'neighbours' and consists of 2 columns, both representing the country's id: c1 c2 1 2 1 3 1 4 1 5 2 4 2 5 2 6 2 10 3 5 4 5 5 7 5 12 6 12 8 9 10 11 13 14 The 2nd table consists of several columns a.o...

Thanks again, that's exactly what i meant!

pbaldy thanks, it worked perfectly

I'm trying to make totals in a query, but instead of using all, I need to leave one out, how to do that? for example the table looks like: A 2 3 B 4 6 C 2 5 D 3 5 E 2 3 How can I leave row 1 out? So that the query will look like: 11 19

Wow you guys are great, is it also possible to do the same, but leave one of the country's away from my totals? For example, if I want to leave country A aside so that the result has to be: country a1 a2 14 11

Hi MStef, Thanks for the quick respond, but I can't open the file because i'm using access 2000 and this is a MS access 2002 file, is there anyway you could convert it to 2000 for me? thanks again

I have to make a query using information out of an existing table. In the table there are two columns which I have to use in the query. I need to have the totals of these two columns. The table looks like this: country amount1 amount2 A 2 3 B 4...