Share via

access query to ID if in a field

Anonymous
2017-05-18T19:50:59+00:00

I think this is probably a very simple thing to do but I can't for the life of me figure it out.  I have a table that contains a series of strategies (about 5000) and corresponding items that are associated with them.  I have a field I inserted into the table that is a likely to be added to list of strategies that need corrections.  I want to write a query that says, find the correction value in the strategies column and spit back the associated columns but I don't know how to say, basically, if in strategies field, in my query.

can someone please point me in the right direction?  thank you for your help!

paul

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2017-05-19T15:39:02+00:00

    Ok, so add both tables to the table pane, join them on the matching field. Then add the status field to the grid along with any other fields you want to show. Set the Criteria row of the status field to whatever status you want to include.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-05-20T16:54:37+00:00

     I want to write a query that says, find the correction value in the strategies column and spit back the associated columns but I don't know how to say, basically, if in strategies field, in my query.

    The way I am reading your post is that you have multiple columns (fields) containing corresponding items that are associated with them.

    If my assumption is correct then your table structure is wrong.   You should have a related table with records (not columns) containing the corresponding items that are associated with them.

    0 comments
  3. Anonymous
    2017-05-19T16:34:15+00:00

    perfect; thank you very much.  I know it's very basic but I just wasn't seeing it.

    thanks again

    paul

    0 comments
  4. Anonymous
    2017-05-19T14:21:48+00:00

    I'm sorry; worked to explain better.  ttried screenshots but that kicks my over 60K limit and can't seem to get it lower.   I have a master list of strategies and related items in table A.  I have a list of strategies that will need a change made in B.  I want to have output where I have the strategy to be changed, its current pricing strategy--these will be the same and will occasionally be duplicative.  where they duplicate, there are different combinations of C,D and E and I want to be able to see them. 

    I'm having difficulty writing a query where my criteria is: I want the information from table A where ToBeChanged is equal to ICHD_CURR_PRICING_STRAT1. The list of ones we need to change will keep getting added to so my goal is to have a query I can re run as I get more information.  when I put a = operator (like preceding) I only get the pricing strategies that happen to be in the same location in their respective files (1st column, 10th row for example)

    thank you for reviewing my question

    0 comments
  5. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2017-05-19T02:04:25+00:00

    I don't understand your question even after reading 3 times.

    Please post a screenshot of the design of the table(s) in question, and some sample text to illustrate the problem.

    0 comments