[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How do I pull a field from a table to a query?

Posted on 2014-08-05
6
Medium Priority
?
156 Views
Last Modified: 2014-08-14
I am having trouble with the query named “Casual_FactorsQry_2”.
I need to pull the “INCIDENT TITLE:” field from the “1-Incident-tbl” table and add it to the “Casual_FactorsQry_2” query.
When I try I get errors or the query does not work.
Root-Cause-Analysis-for-Tunnel-Construct
0
Comment
Question by:cssc1
  • 4
  • 2
6 Comments
 
LVL 36

Accepted Solution

by:
ste5an earned 2000 total points
ID: 40241614
Adding a binary without format description is a little bit problematic. But from your describtion:

This is the reason why we should not use special characters in object names. Use the square brackets to enclose those speical names. E.g.
INSERT  Casual_FactorsQry_2
        ( columnName
        )
        SELECT  [ININCIDENT TITLE]
        FROM    [1-Incident-tbl];
 

Open in new window

0
 

Author Comment

by:cssc1
ID: 40241793
Sorry, but I have a few questions since I am not very knowlwedgable with MS Access:

1. What does "columnName" name mean? I don't think I have any colums?

2. Where di I put this code so it works?

Thanks
0
 
LVL 36

Expert Comment

by:ste5an
ID: 40241962
In this case: Go back to the start..

What does not work? Neither your explanation nor the appended binary explain what you are trying to do or what is going exactly wrong.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:cssc1
ID: 40242372
Sorry, but I attached an image of what I am trying to accomplish.
I hope this helps.
I don't explain things well.
Query.jpg
0
 

Author Comment

by:cssc1
ID: 40245836
does this code go in query?

+++++++++++++++++++++++++++

INSERT  Casual_FactorsQry_2
        ( columnName
        )
        SELECT  [ININCIDENT TITLE]
        FROM    [1-Incident-tbl];
0
 

Author Closing Comment

by:cssc1
ID: 40260662
thanks
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question