Pop_Access's latest activity
-
PI intend to create a trial version of DB, and I want to deactivate the DB automatically after certain days. Is there an idea.
-
PPop_Access replied to the thread Calculate Percentage without Empty Fields.Thank you for your advice regarding using "&" instead of "+" I multiply by 100 to display the result before the comma, then I used ",2"...
-
PPop_Access replied to the thread Calculate Percentage without Empty Fields.Thank you for your Idea. the problem has been solved by using the following formula:-...
-
PPop_Access reacted to Pat Hartman's post in the thread Calculate Percentage without Empty Fields with
Like.
If your amounts default to null, the Avg() function works correctly since it ignores null. So if you have three rows with the following... -
PPop_Access replied to the thread Calculate Percentage without Empty Fields.Great job; It was very easy😎
-
PPop_Access reacted to arnelgp's post in the thread Calculate Percentage without Empty Fields with Like.
replace Count(*) with Count([Evaluation])
-
PPop_Access replied to the thread Calculate Percentage without Empty Fields.I would like to share with you what I did, I wrote the following code in unbound textbox in the report footer:-...
-
PPop_Access reacted to theDBguy's post in the thread Calculate Percentage without Empty Fields with Like.
Okay, thanks for the clarification. You could try using DCount(). For example. DCount("*", "TableName", "FieldName>=4.5") / DCount("*"...
-
PPop_Access reacted to arnelgp's post in the thread Calculate Percentage without Empty Fields with Like.
you create 3 queries: 1st query (query1): SELECT Sum(yourTable.Mark) AS TotalMarks FROM yourTable HAVING (((Sum(yourTable.Mark))>4.5))...
-
PPop_Access replied to the thread Calculate Percentage without Empty Fields.I really believe you ;)
-
PPop_Access reacted to Eugene-LS's post in the thread Calculate Percentage without Empty Fields with Like.
I think this is solvable, besides you can use IIF inside another IIF ... BTW - The longest IIF expression I've seen: Analysis_Result...
-
PPop_Access replied to the thread Calculate Percentage without Empty Fields.Thank you, but the number of fields is not fixed
-
PPop_Access replied to the thread Calculate Percentage without Empty Fields.sorry; this field should be empty, but to keep the row, I wrote the text "Afgf" with white color
-
PHi All, How I can calculate the percentage for a numeric field in report with the following conditions: 1- field is not empty...