Search results

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...

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

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...