I am in need of some assistance with a formula within a query in Access. My first formula would be adding column 1, column 2 and column 3 together. The sum of these three columns would be in column 4. The part I need help with is this; how can I find what the percentage of column 4 would be of column 5? Any help would be appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formulas in a query
- Thread starter abbigale
- Start date
Dugantrain
Active Member
- Joined
- Feb 10, 2003
- Messages
- 354
-First Part:
Column 4:[column 1]+[column 2]+[column 3]
-Second Part:
Column 4
[column 1]+[column 2]+[column 3])/([column 5]) and Format as Percent, choosing however many decimal places you'd like.
Column 4:[column 1]+[column 2]+[column 3]
-Second Part:
Column 4
[column 1]+[column 2]+[column 3])/([column 5]) and Format as Percent, choosing however many decimal places you'd like.
Upvote
0
The columns that are involved in the formulas is formatted as currency. My next question is, how can I change the format from currency to a percentage. I do not see an option to change the format unless you are in a table. Thanks for your help.
Upvote
0
The columns that are involved in the formulas is formatted as currency. My next question is, how can I change the format from currency to a percentage. I do not see an option to change the format unless you are in a table. Thanks for your help.
Upvote
0
The columns that are involved in the formulas is formatted as currency. My next question is, how can I change the format from currency to a percentage. I do not see an option to change the format unless you are in a table. Thanks for your help.
Upvote
0
Dugantrain
Active Member
- Joined
- Feb 10, 2003
- Messages
- 354
In Design View, click the field that you want to format. In the toolbar, Click on Properties. You'll see the Format option. Format as Percentage.
Upvote
0
Similar threads
- Question
- Solved
