hi!

i've built a front-end on DAP. built a query that consist of fields from 2 different tables. to view the query on DAP, i've used pivot table. in query i've a condition for the field to list all item yes and no, ie effectively all items, as i wanted to see in the total list which items are yes and which are no. therefore, under the criteria, i've put ["Y" & ""]. when viewed from the pivot table only those with "Y" came up. in relationship, i've assigned the join properties as "include ALL records from Table1 and only those records from Table2 where the joined fields are equal".

anyone any idea where i went wrong?

appreciate the help ...