GENERATION OF REPORT (1 Viewer)

[sbaud2003]

Is it possible to generate a report, in which first all address will be shown and then the all Name and other details from a single table


for exampel it should be like this

To
add1
add 2
add3
ad4

The details are as follws

1. mr david, team leader
2. mr Robin, head reader
etc etc

 

[GaP42]

It is straightforward to obtain the name and the "role" of the person from a single table. If that is what you have:
1. create the select query, to include name and role, from your table (and think about the sort order of records). Check it. Save the query
2. create the report (report design) and use the saved query from step 1 as your datasource. Add the controls for name and role. Test it

If, however you have multiple roles (or addresses) for a person in a single table then you have a problem - the table structure likely is not properly normalised. You could provide a view of the relationships (Database Tools --> Relationships)

 

[Pat Hartman]

The short answer is yes, of course. But we can't help with any details without seeing your table design. Post a picture of the relationship window showing how tables are related. Make sure that the images are expanded so that we can see the relevant column names.

 

[Pat Hartman]

@sbaud2003 The folks who answer questions here are adults and although we appreciate likes, liking a question doesn't contribute to the conversation. It would have been better to do what was asked or tell us you solved the problem.