Hello Experts:
On a form, I use various Dcounts to calculate n/N.
For example, I have the following objects:
- Table [tbl_Source] having 10 records.
- Query "qry01_Complete" returns 6 records.
- Query "qry02_Partially_Complete" returns 3 records.
- Query "qry03_Not_Started_Yet" returns 1 record.
Now, when you open up the form "F01_MainMenu", the following calculated values are displayed in the bright yellow textboxes:
- 60.0%
- 30.0%
- 10.0%
These percentages are calculated via the following Dcount expression for, e.g., the top yellow textbox:
=FormatPercent(DCount("*","qry01_Complete")/DCount("*","tbl_Source"),1)
Improved Display (Question):
- I plan on changing the yellow background to match the dark blue background (with white font).
- I will also attempt to somehow line up the unbound textboxes with the listbox so that it appears that the % are part of the listbox.
- However, if you know of another/better way to somehow concatenate the % values into the listbox itself -- WITHOUT INTERFERING THEIR ROWSOURCE QUERY CALLS -- that would be even preferred. Any thoughts if that is somehow doable?
Thank you,
Tom
P.S. See attached the DB and screenshot of the current Dcount outputs.