How to use a field without including it in other Table in MS Access?
up vote
0
down vote
favorite
I have a simple data of employees with their ID,Name,Salary and other fields in a table named EMP_DUES. I want to make another table and use a calculated field which is 10% of total salary, without using the salary field in this new table.
But when I try the expression: EMP_DUES.[GROSS_PAY]*0.1 for that field, it gives a error saying "The expression cannot be saved because it refers to another table".
The Table.
How I want it to be
ms-access
asked Nov 8 at 15:54
Python03
9117
add a comment |
up vote
0
down vote
favorite
I have a simple data of employees with their ID,Name,Salary and other fields in a table named EMP_DUES. I want to make another table and use a calculated field which is 10% of total salary, without using the salary field in this new table.
But when I try the expression: EMP_DUES.[GROSS_PAY]*0.1 for that field, it gives a error saying "The expression cannot be saved because it refers to another table".
The Table.
How I want it to be
ms-access
asked Nov 8 at 15:54
Python03
9117
1
Are you sure you want to make another table, or are you looking for a query?
– Unhandled Exception
Nov 8 at 18:28
@UnhandledException : I just need anything but that thing should not include that salary field in its Datasheet view.
– Python03
Nov 9 at 18:21
Ok, so lets think about a query. Given the picture you provided, please tell us how the result should look like (maybe also by using a picture additionally).
– Unhandled Exception
Nov 9 at 19:34
@UnhandledException: Added.
– Python03
Nov 10 at 8:22
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a simple data of employees with their ID,Name,Salary and other fields in a table named EMP_DUES. I want to make another table and use a calculated field which is 10% of total salary, without using the salary field in this new table.
But when I try the expression: EMP_DUES.[GROSS_PAY]*0.1 for that field, it gives a error saying "The expression cannot be saved because it refers to another table".
The Table.
How I want it to be
ms-access
asked Nov 8 at 15:54
Python03
9117
I have a simple data of employees with their ID,Name,Salary and other fields in a table named EMP_DUES. I want to make another table and use a calculated field which is 10% of total salary, without using the salary field in this new table.
But when I try the expression: EMP_DUES.[GROSS_PAY]*0.1 for that field, it gives a error saying "The expression cannot be saved because it refers to another table".
The Table.
How I want it to be
ms-access
ms-access
asked Nov 8 at 15:54
Python03
9117
asked Nov 8 at 15:54
Python03
9117
edited Nov 10 at 8:21
asked Nov 8 at 15:54
Python03
9117
asked Nov 8 at 15:54
Python03
9117
asked Nov 8 at 15:54
Python03
9117
9117
1
Are you sure you want to make another table, or are you looking for a query?
– Unhandled Exception
Nov 8 at 18:28
@UnhandledException : I just need anything but that thing should not include that salary field in its Datasheet view.
– Python03
Nov 9 at 18:21
Ok, so lets think about a query. Given the picture you provided, please tell us how the result should look like (maybe also by using a picture additionally).
– Unhandled Exception
Nov 9 at 19:34
@UnhandledException: Added.
– Python03
Nov 10 at 8:22
add a comment |
1
Are you sure you want to make another table, or are you looking for a query?
– Unhandled Exception
Nov 8 at 18:28
@UnhandledException : I just need anything but that thing should not include that salary field in its Datasheet view.
– Python03
Nov 9 at 18:21
Ok, so lets think about a query. Given the picture you provided, please tell us how the result should look like (maybe also by using a picture additionally).
– Unhandled Exception
Nov 9 at 19:34
@UnhandledException: Added.
– Python03
Nov 10 at 8:22
1
1
Are you sure you want to make another table, or are you looking for a query?
– Unhandled Exception
Nov 8 at 18:28
Are you sure you want to make another table, or are you looking for a query?
– Unhandled Exception
Nov 8 at 18:28
@UnhandledException : I just need anything but that thing should not include that salary field in its Datasheet view.
– Python03
Nov 9 at 18:21
@UnhandledException : I just need anything but that thing should not include that salary field in its Datasheet view.
– Python03
Nov 9 at 18:21
Ok, so lets think about a query. Given the picture you provided, please tell us how the result should look like (maybe also by using a picture additionally).
– Unhandled Exception
Nov 9 at 19:34
Ok, so lets think about a query. Given the picture you provided, please tell us how the result should look like (maybe also by using a picture additionally).
– Unhandled Exception
Nov 9 at 19:34
@UnhandledException: Added.
– Python03
Nov 10 at 8:22
@UnhandledException: Added.
– Python03
Nov 10 at 8:22
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Ok, thanks for missing information. So finally thats your query:
Select EMP_ID, EMP_NAME, [GROSS_PAY]*0.1 As [10% OF GROSS_PAY] From EMP_DUES
To use it, create a new query, switch to SQL view, paste the query, save, name and close it, and finally open it like a table.
answered Nov 10 at 8:30
Unhandled Exception
71047
Just one more question, What would be the query if I have also another table named x and a field y in it and I want the field in query to show [BASIC_PAY]-[y]
– Python03
Nov 11 at 13:37
Sorry, I can't follow. I would need more details.
– Unhandled Exception
Nov 11 at 17:41
Never mind,I got it.
– Python03
Nov 12 at 15:19
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Ok, thanks for missing information. So finally thats your query:
Select EMP_ID, EMP_NAME, [GROSS_PAY]*0.1 As [10% OF GROSS_PAY] From EMP_DUES
To use it, create a new query, switch to SQL view, paste the query, save, name and close it, and finally open it like a table.
answered Nov 10 at 8:30
Unhandled Exception
71047
Just one more question, What would be the query if I have also another table named x and a field y in it and I want the field in query to show [BASIC_PAY]-[y]
– Python03
Nov 11 at 13:37
Sorry, I can't follow. I would need more details.
– Unhandled Exception
Nov 11 at 17:41
Never mind,I got it.
– Python03
Nov 12 at 15:19
add a comment |
up vote
0
down vote
Ok, thanks for missing information. So finally thats your query:
Select EMP_ID, EMP_NAME, [GROSS_PAY]*0.1 As [10% OF GROSS_PAY] From EMP_DUES
To use it, create a new query, switch to SQL view, paste the query, save, name and close it, and finally open it like a table.
answered Nov 10 at 8:30
Unhandled Exception
71047
Just one more question, What would be the query if I have also another table named x and a field y in it and I want the field in query to show [BASIC_PAY]-[y]
– Python03
Nov 11 at 13:37
Sorry, I can't follow. I would need more details.
– Unhandled Exception
Nov 11 at 17:41
Never mind,I got it.
– Python03
Nov 12 at 15:19
add a comment |
up vote
0
down vote
up vote
0
down vote
Ok, thanks for missing information. So finally thats your query:
Select EMP_ID, EMP_NAME, [GROSS_PAY]*0.1 As [10% OF GROSS_PAY] From EMP_DUES
To use it, create a new query, switch to SQL view, paste the query, save, name and close it, and finally open it like a table.
answered Nov 10 at 8:30
Unhandled Exception
71047
Ok, thanks for missing information. So finally thats your query:
Select EMP_ID, EMP_NAME, [GROSS_PAY]*0.1 As [10% OF GROSS_PAY] From EMP_DUES
To use it, create a new query, switch to SQL view, paste the query, save, name and close it, and finally open it like a table.
answered Nov 10 at 8:30
Unhandled Exception
71047
answered Nov 10 at 8:30
Unhandled Exception
71047
answered Nov 10 at 8:30
Unhandled Exception
71047
answered Nov 10 at 8:30
Unhandled Exception
71047
71047
Just one more question, What would be the query if I have also another table named x and a field y in it and I want the field in query to show [BASIC_PAY]-[y]
– Python03
Nov 11 at 13:37
Sorry, I can't follow. I would need more details.
– Unhandled Exception
Nov 11 at 17:41
Never mind,I got it.
– Python03
Nov 12 at 15:19
add a comment |
Just one more question, What would be the query if I have also another table named x and a field y in it and I want the field in query to show [BASIC_PAY]-[y]
– Python03
Nov 11 at 13:37
Sorry, I can't follow. I would need more details.
– Unhandled Exception
Nov 11 at 17:41
Never mind,I got it.
– Python03
Nov 12 at 15:19
Just one more question, What would be the query if I have also another table named x and a field y in it and I want the field in query to show [BASIC_PAY]-[y]
– Python03
Nov 11 at 13:37
Just one more question, What would be the query if I have also another table named x and a field y in it and I want the field in query to show [BASIC_PAY]-[y]
– Python03
Nov 11 at 13:37
Sorry, I can't follow. I would need more details.
– Unhandled Exception
Nov 11 at 17:41
Sorry, I can't follow. I would need more details.
– Unhandled Exception
Nov 11 at 17:41
Never mind,I got it.
– Python03
Nov 12 at 15:19
Never mind,I got it.
– Python03
Nov 12 at 15:19
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53211418%2fhow-to-use-a-field-without-including-it-in-other-table-in-ms-access%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Are you sure you want to make another table, or are you looking for a query?
– Unhandled Exception
Nov 8 at 18:28
@UnhandledException : I just need anything but that thing should not include that salary field in its Datasheet view.
– Python03
Nov 9 at 18:21
Ok, so lets think about a query. Given the picture you provided, please tell us how the result should look like (maybe also by using a picture additionally).
– Unhandled Exception
Nov 9 at 19:34
@UnhandledException: Added.
– Python03
Nov 10 at 8:22