devillawyer
New member
- Local time
- Today, 11:32
- Joined
- Jan 11, 2022
- Messages
- 1
Hello All,
I am working on request management database. There is 6 types of request, hence each type is stored in different table. In each type of request there are several data points like Drafter, Capacity Drafter which repeats in each request type. I would like to pull out only those 2 data points form each table and include in Table Request Totals (Table contains fields named as the above). I believe the best way to do so it to run append query. However, when I am trying to run it, nothing happens.
Below SQL code:
INSERT INTO [Request Totals] ( Drafter, [Capacity Drafter], Drafter, [Capacity Drafter] )
SELECT [BAA Requests List].Drafter, [BAA Requests List].[Capacity Drafter], [NDA Requests List].Drafter, [NDA Requests List].[Capacity Drafter]
FROM [BAA Requests List], [NDA Requests List];
This query should append only new request. When I am trying to run it, nothing happens. Not even message that ´you are about to append x records´ nor any error.
I am new to Access and I am self learner so I would much apricate your support. Please let me know if I can explain anything further to help you understand the issue.
I am working on request management database. There is 6 types of request, hence each type is stored in different table. In each type of request there are several data points like Drafter, Capacity Drafter which repeats in each request type. I would like to pull out only those 2 data points form each table and include in Table Request Totals (Table contains fields named as the above). I believe the best way to do so it to run append query. However, when I am trying to run it, nothing happens.
Below SQL code:
INSERT INTO [Request Totals] ( Drafter, [Capacity Drafter], Drafter, [Capacity Drafter] )
SELECT [BAA Requests List].Drafter, [BAA Requests List].[Capacity Drafter], [NDA Requests List].Drafter, [NDA Requests List].[Capacity Drafter]
FROM [BAA Requests List], [NDA Requests List];
This query should append only new request. When I am trying to run it, nothing happens. Not even message that ´you are about to append x records´ nor any error.
I am new to Access and I am self learner so I would much apricate your support. Please let me know if I can explain anything further to help you understand the issue.