forgot to include field from table on query

[DAPPLE]

Is there any way to go back and get a field from a table that somehow didn't get included on the query?

 

[audrey]

If I'm understanding you question correctly this is what you do:

Open your query in design view. You should see the table(s) that you query is based on in the top box. Scroll through your field list in the table that contains the field that you forgot. When you find the field just click and drag in onto your query design. Then enter any criteria if needed.

Audrey

 

[kavarin]

In the upper window of the design view of the query, right-click and select "SHOW TABLE". Select the appropriate table and drag the required field from that table into the grid on the lower portion of your screen.

HTH

 

[DAPPLE]

Ok, I selected the table as kavarin suggested and dragged the field to the grid in design view of the query (this was an append query), then I wasn't sure what to do next, so I clicked "!" run. This is the error msg I got - cannot find output table...
Any ideas - please and thank you.

 

[DAPPLE]

I may have done some damage - I broke out the book, followed the steps, and discovered I forgot the step to 'append query' So I found Sal01 field from LOS table (that was the one field missing) and dropped it into the main table. Maybe that wasn't the best decision. Now, I have a ton of sal01 amounts in the main table, they're just isolated... no other data in the other columns for those particular rows. The sal amounts didn't match up with the names. How do I go back and 'undo' what I did?? Next step, how do I get it right next time?
Thanks in advance

 

[DBL]

Don't panic! I think you need to relate that new table to the other table(s) in the query. Click on the join field in the main table and drag it over and join it to the corresponding field in the newly added table

 

[DAPPLE]

What I did before reading your resonse was: I selected those salary amts that were added as new records to my main table, and deleted those records because they weren't matched up with names anyway. Then I went and deleted the append query that was responsible for it. So, basically I'm back at square one. What should I do from here?
Brief diagriam of my project:
dbSoutheast Region Compensation - it contains three tables 1. main table, 2.LOS info, 3. Other company info.
Tables two and three were queried together to form the main table.
One field from the LOS table is missing in the main table though. I need to get it inserted. Would terribly appreciate the help!

 

[DBL]

Okay, can I just check, you have used table LOSInfo and table OtherCustomerInfo to create a third table Main Table. You did this by using a Create Table Query? but you forgot to add a field from LOSInfo to the make table query before you ran it? Are you going to dump the LOSInfo and OtherCustomerInfo tables once you've got the Main table set up correctly?

I would go back and create another Make Table query with the fields from the other two tables you need and run it again. Create an ordinary query and then use the Query Type button on the toolbar, to the left of the ! run button, and select Make Table query from the list of options. Name it something other than Main Table until you make sure it's right.