Select from different table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a couple of tables with data regarding jobs that we run in our
manufacturing facility. Some of this data are estimated hours to run a
certain tool. I already have a query set up to select all the records that I
need to look at and the corresponding estimated hours per piece. However, I
would like to be able to single out the items that have the word "SEGMENT" in
their description and then have the query choose the estimated hours per
piece from a seperate table than everything else is being selected from. Can
someone help me with this? Please keep in mind that I am NOT familiar with
SQL language and I build my queries and such using the (non-SQL method). I
think this methods is for dummies like myself. Can someone please help me?
 
Just use a LIKE "*SEGMENT*" in your field criteria to pull only the "segment"
records. Pulling information from the 2nd table shouldn't be difficult if
you have a key to link them with. You just need to include the 2nd table and
drag a field from one table to its related field in the other.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing values? 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Determine Max Record 1
Access Updating inventory levels 0
ACCESS forms with multiple... 2
Subreport from union query 2
Comparing records by year in a report 2
Subform causing duplicate records? 7

Back
Top