Home

Search and Return all values that match the search criterion/criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-419461%22%20slang%3D%22en-US%22%3ESearch%20and%20Return%20all%20values%20that%20match%20the%20search%20criterion%2Fcriteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-419461%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%203%20tables%3A%20tblGeneralInfo%2C%20tblCap_Airflow%2C%20and%20tblCap_Yes%2FNoQuestions%20and%20a%20form%20with%202%20buttons%3A%20Airflow%20and%20DER%20Repairs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20relationships%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20601px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106393iDC026A0C13B92BCF%2Fimage-dimensions%2F601x378%3Fv%3D1.0%22%20width%3D%22601%22%20height%3D%22378%22%20alt%3D%22relationship.JPG%22%20title%3D%22relationship.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3EThe%20Airflow%20column%20from%20the%20tblCap_Airflow%20is%20a%20multi-valued%20field%20where%20a%20Company%20can%20have%20many%20Airflow%20capabilities%20which%20allows%20the%20%22Company%20Name%22%20column%20to%20have%20repeated%20company%20names%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20622px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106395iEA7B0451BCAAA4E1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22airflow%20table.JPG%22%20title%3D%22airflow%20table.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI'm%20looking%20to%20create%20a%20form%20using%20tblCap_Airflow%20that%20is%20able%20to%20return%20all%20Company%20Names%20and%20their%20corresponding%20Details%20(if%20available)%20with%20respect%20to%20the%20selected%20Airflow%20value%20and%20when%20the%20%22Airflow%22%20button%20is%20clicked%2C%20the%20form%20is%20prompted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EDesired%20result%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelected%20Airflow%20Value%20%3D%20CCDI%20massflow%20machine%3C%2FP%3E%3CP%3ENumber%20of%20Companies%20%3D%204%3C%2FP%3E%3CP%3EList%20of%20Company%20Names%3A%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20CHR%3C%2FP%3E%3CP%3E3.%20ETH%3C%2FP%3E%3CP%3E4.%20REV%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EThe%20%22Performing%20DER%20Repairs%22%20column%20from%20tblCap_Yes%2FNoQuestions%20is%20also%20a%20multi-valued%20field%20with%20returns%20only%20Yes%20or%20No%2C%20therefore%2C%20the%20company%20names%20in%20the%20%22Company%20Name%22%20column%20only%20occur%20once%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20636px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106396i28172C38349C78B3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22yesno%20table.JPG%22%20title%3D%22yesno%20table.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFor%20this%20table%2C%20I'm%20looking%20to%20do%20the%20same%20things%20as%20mentioned%20above%2C%20however%2C%20only%20count%20and%20return%20company%20names%20that%20have%20%22Yes%22%20in%20the%20%22Performing%20DER%20Repairs%22%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20create%20a%20combo%20box%20for%20Airflow%20to%20select%20Airflow%20option%20but%20it%20doesn't%20seem%20to%20work.%20The%20drop%20down%20list%20contains%20repeated%20values%2C%20not%20unique%20ones%20and%20it%20either%20only%20returns%20one%20company%20name%20at%20a%20time%20(not%20all%20companies)%20OR%20doesn't%20return%20anything%20at%20all.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20405px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106403iE746B030262D7B6D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22result.JPG%22%20title%3D%22result.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20have%20any%20experience%20with%20Access%20and%20this%20is%20my%20first%20time%20dealing%20with%20it.%26nbsp%3BPlease%20can%20anyone%20show%20me%20how%20to%20go%20about%20this%3F%20Thank%20you%20so%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-419461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
trdoan
New Contributor

Hi everyone,

 

I have 3 tables: tblGeneralInfo, tblCap_Airflow, and tblCap_Yes/NoQuestions and a form with 2 buttons: Airflow and DER Repairs.

 

Here are the relationships:

relationship.JPG

  • The Airflow column from the tblCap_Airflow is a multi-valued field where a Company can have many Airflow capabilities which allows the "Company Name" column to have repeated company names

airflow table.JPG

I'm looking to create a form using tblCap_Airflow that is able to return all Company Names and their corresponding Details (if available) with respect to the selected Airflow value and when the "Airflow" button is clicked, the form is prompted.

 

Desired result:

 

Selected Airflow Value = CCDI massflow machine

Number of Companies = 4

List of Company Names: 

1. A     

2. CHR

3. ETH

4. REV

 

  • The "Performing DER Repairs" column from tblCap_Yes/NoQuestions is also a multi-valued field with returns only Yes or No, therefore, the company names in the "Company Name" column only occur once

yesno table.JPG

For this table, I'm looking to do the same things as mentioned above, however, only count and return company names that have "Yes" in the "Performing DER Repairs" column.

 

I tried to create a combo box for Airflow to select Airflow option but it doesn't seem to work. The drop down list contains repeated values, not unique ones and it either only returns one company name at a time (not all companies) OR doesn't return anything at all.

result.JPG

 

I don't have any experience with Access and this is my first time dealing with it. Please can anyone show me how to go about this? Thank you so much!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies