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.


Change DCount output (in unbound textbox) from, e.g., "0.6" to "60.0%"
Reply With Quote
