Filtered Report

[Voodeux2014]

I have created a database over the past few days with help from user's on this forum for a couple of hurdles I could not figure out. I now have a fully functional database but would like to create a report that shows all of the unassigned assets (e.g. computers, phones, monitors) from multiple tables and have them displayed on a report for easy viewing. What is the best way to do this?

[rpeare]

create a query with your asset table, add your asset assigned to table make sure the arrow is pointing FROM your asset table TO your asset assigned to table. using the PK value from your asset assigned to table put in the criteria:

IS NULL