Viewing customers per city

[MartinX]

I have a database (see attached file) containing a list of customers. I have their adresses stored in a seperate table so I can keep track of their previous adresses.

I would like to make a layout listing all clients per city, somewhat like this:

Stockholm

'--- Customer one

'--- Customer two

Gothenburg

'--- Customer three

'--- Customer four

'--- Customer five

Malmo

'--- Customer six

I appreciate all help in this, thanks!

customers.zip

[Genx]

... you need to make a report... so make a new layout and attach it to your Address Table occurance... on the new layout you will need to have at least

1) A Sub Summary Part

2) A Body

You will put the city in the sub summary part and the related client names that are related to each particular address in the body.. you will then sort your records by city...

i modified your file to add the report in...

customers.zip

[MartinX]

That's exactly what I need. Thanks a million

[Genx]

glad i could help

[mzimmers]

So...on the subject of reports...I'm trying to create a report that will involve three levels of summary. (This is my first report effort.) Do I need to have three separate fields somewhere to hold these for me?

Where do most people put summary fields, anyway? Do they go into a separate table, or do people just imbed them into the table on which they wish to report?

[Genx]

no no no... summary should reside in the table you want to report on...

also if your going to be doing a summary based on the same criteria i.e. the sum of a particular field, you can just put it into a sub summary part and it will produce different results for each sorted summary... if you put it into multiple sub summary parts, i.e. a major summary, a secondry summary, it will also re-evaluate appropriatly here...

hope this helped, if it didnt ask for more

~genx