Is it possible to display multiple records on a single form?

[Vulfson]

Hello everyone.

I have an odd question, and I'm not even sure its possible. One of the projects I am working on requires me to display the status of 8-10 items on one page. Normally this wouldnt be a problem, I would simply build a form in tabular format, or the like, displaying each record in series.

HOWEVER...

This particular project is unique in that I need to essentially build a "dashboard" that displays a single field (conditionally formatted to change color) from each record against a larger graphic in the background. This would give a "map" of the status of all the projects in a simple picture interface. Each field on the map would display the current condition of that project.

Can this even be done in Access? Or am I going to need to look elsewhere to solve the problem?

 

[Liv Manto]

Yes it can be done, by dashboard if you are talking about a chart, you can create a chart.

 

[Vulfson]

Thanks for the reply, and I did find a way to do it. It's not the most elegant solution in the world, but you can brute force the problem by making a custom query that accesses the table multiple times. I think this would be a problem with a database that was intended to grow, but this one will be static, and only the values of some of the existing records will change.

Thanks again.