Search results

This project started as an Excel spreadsheet. In that form I had 3 columns ...one to show the ID # of the criteria, one to show the text of the criteria, and one for the grade. So I had 90 rows that could be pre-populated with the criteria ID, criteria text and the grade was blank..to be added...

I like this idea and see how it fits together. My only problem is that my "TBL assessment details" does a lookup from the Tbl_ surveys and it pulls the assessment ID as number, when the user really needs to select a facility/date of assessment combo. The lookup from assessment ID to the...

Appreciate that idea. I was thinking that since I might need to edit criteria or add criteria in the future it would be best to have them in a separate table.

Thanks ! Each facility assessment does always include all 90 criteria. Yes, potentially new criteria could be added. But not likely big numbers of additions. The scoring is qualitative like stoplight scoring ie red, yellow or green. No need to sum or average, but a need to total all reds...

I'm developing a database that involves scoring a facility on a list of about 90 different criteria. I have a table that collects a score for each criteria, for each facility, for each date of assessment, and in general my tables and relationships are working well. Now I'm to the point of...

Hello everyone. My name is Steve and my primary job is as a trauma surgeon but in my administrative roles I often need to manipulate data. Many years ago I started in Dbase and then transitioned to Access for a while before I pretty much stopped needing personalized databases. Now I'm back to...