February 16, 200619 yr Newbies 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
February 17, 200619 yr ... 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
February 18, 200619 yr 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?
February 20, 200619 yr 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
Create an account or sign in to comment