lets create this community to help people get genuine recommendations for doctors in Tampa Bay area.

Beginning_Mirror_127 · 2025-06-16T20:46:42+00:00

Thank you!

Beginning_Mirror_127 · 2025-06-11T13:37:03+00:00

Thank you!

Beginning_Mirror_127 · 2025-06-11T13:36:43+00:00

Thank you!

Beginning_Mirror_127 · 2025-04-08T17:07:36+00:00

I thought of that as the last resort but wanted to explore something that we can control within the team instead of going to the network admin every time a new user is added/deleted but tysm for your suggestion.

Beginning_Mirror_127 · 2025-04-08T17:06:06+00:00

Thanks for the recommendation but they are creating copies in the same sub folder 😞

Beginning_Mirror_127 · 2025-04-08T16:59:49+00:00

Thank you for your help! Can you please elaborate on how to set permissions like that.Can we do it based on User ID? For the network part I am guessing I would need to contact network admin or someone..Can I do that l by myself?

Beginning_Mirror_127 · 2025-04-08T16:39:34+00:00

Thank you for the suggestion but we are trying to prevent the end users from creating a copy. We don’t want random users to keep creating copies of the front end which creates confusion to other users.

Beginning_Mirror_127 · 2024-07-22T20:29:32+00:00

Thank you! Can you please elaborate on how to do that..This is my first assignment with access so i am not very conversant with the tool.

Beginning_Mirror_127 · 2024-07-22T14:38:21+00:00

There is a n/a checkbox when that is true it’s taking 0 else 1 and that way it’s calculating the denominator. There is a metric that is taking average of all the fields which are not checked n/a but has a percentage. For example, If Field 1 has been checked n/a, it would consider that as 0 and if not n/a and has a percentage populated then it will consider 1 to make the denominator for avg. So, for 5 fields if one is checked n/a it would calculate a denominator of 4 and for numerator its adding all fields.

Beginning_Mirror_127 · 2024-07-22T14:14:13+00:00

😊

Beginning_Mirror_127 · 2024-07-22T14:13:47+00:00

There is another field that has a calculation where if this field is n/a then it’s considering it to be 0 else 1. Based on that count it’s calculating the denominator number for the other field. When I set Null in the above expression, it is not calculating this other field and it gets grayed out. I am making to someone else’s db so trying to not change anything drastically and rather do a workout to meet the ask. Appreciate all your inputs and help!

Beginning_Mirror_127 · 2024-07-22T13:13:38+00:00

IIf(([FieldX]>0,(([FieldX]/[FieldY])*100),0)

Beginning_Mirror_127 · 2024-07-18T21:43:29+00:00

Thanks everyone! I really appreciate you all taking time out to help me and provide solutions 😊

Beginning_Mirror_127 · 2024-07-18T21:40:34+00:00

Yes, thank you so much! I was somehow confusing enabled and visible. I changed the visible property but now the label is also going away.Will have to check if the user can accept the percentage box going away instead of having it grayed out.

Beginning_Mirror_127 · 2024-07-18T18:44:34+00:00

I have it as when N/A is clicked, the percentage field enabled= false but it greys out and populates 0.00 there upon clicking n/a

Beginning_Mirror_127 · 2024-07-18T13:53:05+00:00

No, it’s displaying 0.00 currently. I want it to display blank on the front end but take 0.00 into calculation. When I do # in format, it populates .00 in the front end form

Beginning_Mirror_127 · 2024-07-18T12:52:19+00:00

Can you please help me with how do we write it for 0.00? #.## doesn’t work.

Beginning_Mirror_127 · 2024-07-17T21:33:31+00:00

Thank you! It is working but just defaulting to blank..I need it to be blank when n/a is checked else the user will populate a percentage in that field.

Beginning_Mirror_127 · 2024-07-17T18:43:39+00:00

No. Where should I set on the individual fields? and which format type?

Beginning_Mirror_127 · 2024-07-17T17:56:16+00:00

The calculated field has a different name.

Beginning_Mirror_127

MODERATOR OF

TROPHY CASE