TABLE FIELDS NOT APPEARING IN DETAIL SECTION

M

MichaelAngelo

I have a complex query that generates a report the query includes an inner
join and left join.The fields from the other tables appear fine on the report
but the one that doesn't show up is from a table called attachment .The field
not showing up is the attachment type.Can anyone please help me out.I have
selected that field in the Query design view to be shown but I don't know why
it doesnt turn up.

Also related to this does anyone know how it is possible to have 2 detail
sections in a single access report.
 
D

Duane Hookom

We can't see your data or relationships so it is impossible to tell why
attachment type doesn't display. Does the field display in the query?

You can have lots of detail sections. Create a lowest level of sorting and
grouping based on your record source's primary key. Display the primary
key's header and footer and you will have 3 detail sections.
 
Top