GENERATION OF REPORT

sbaud2003

Member
Local time
Tomorrow, 03:21
Joined
Apr 5, 2020
Messages
186
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
 
Last edited:
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)
 
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.
 
@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.
 

Users who are viewing this thread

Back
Top Bottom