Trying to build a dynamic splash page

[ZeroWard]

Hi everyone,

Just going to start this out with a little disclaimer, I've very new to the whole access and database building world. Apologies if this question is a little vague, or I have a completely wrong concept of what I can even do.

Some background on the database:
It's going to be used to track inspections, and will require both a primary and secondary inspection input.

What I want to do:
I want to create some sort of dynamic graph that displays the ratios of inspections done to the total, so we can have a visual idea of what needs to be accomplished. Also, beside the navigation buttons (which I have built), I would like to add some sort of subreport (not sure if that's the correct term) that would display those inspections which still require a secondary look.

Any input and advice would be greatly appreciated!

Thanks!

[ranman256]

both inspections would input as 2 records (but different inspectors) but the same [InspectionSite].
you would build a query to pull data from [InspectionSite] (giving 2 records)
build a 'chart' (graph report) off this query to show the differences. (use the chart wizard)

[ZeroWard]

So they could be in the same table, it would just consist of two different entries?