question- how to lay this out?

timfitz256

New member
Local time
Yesterday, 20:43
Joined
Oct 17, 2019
Messages
6
I'm new to Access, and have so far created a pretty good database, (my opinion only) LOL
I'm wanting to make a counts listing for my database.. (I was requested to do this by the powers that be at my work)..
in the picture, you'll see the layout I'm wanting to create, I've drawed it out on paper.. I've tried a little bit, but can't get to where I need to.. I'm create micro's or a Module.. that is something I've not worked very much with... please check out the picture.. tell me what you think..?? if it can be done..?? etc.. how to lay it out??
Thanks in advance for the help

layout.jpg
 
Hi. Looks like you're creating some sort of a dashboard. This is possible using an unbound form and a few (bunch) of expressions or a module to lookup and populate it with data.
 
Looks like its best realized as a Report.

If your data is properly structured, this can be achieved with a main report which display the first 3 sections and a sub-report to show the Total section.

I would start by googling and working through a few Access Report Tutorials.
 

Users who are viewing this thread

Back
Top Bottom