Search results

SELECT Enrollee_Data.FirstName, Enrollee_Data.MiddleName, Enrollee_Data.LastName, Enrollee_Data.RegistrationDate, Enrollee_Data.BirthDate, Enrollee_Data.Race_Ethnicity, Enrollee_Data.Country_ofOrigin_Ethinicity, Enrollee_Data.Gender, Enrollee_Data.Street_Adrs1, Enrollee_Data.Street_Adrs2...

If so, then how would I be able to include those fields? (Some records have fields that have null values, while others have the same fields filled in, but have null values in others). If I were to show the query, do I show it in SQL format?

Nothing changed. I'm still getting no records. That's what I'm trying to aim for - a single query that could search records based on several criteria, where criteria are selectable by the form. Therefore, I thought of using the "Like" statements so that it would select all the records that...

I'm trying to make a search form that makes use of queries that search a table based on what fields I have. How would I go about having the query display all the fields for the record(s) that match the search criteria? This is for Access 2010. As far as the query is set up, I have several...

Okay, that part works. Thank you. Now I have another question about the same search form - I'm making this search form search up two forms - one of which is working now. The other I'm trying to use the search form to search up a criteria, but within the search results, display all the fields...

The query works on the search form by itself when not in a navigation form. But when I use the same search form as a subform under a navigation form, it asks me for the value of the textbox, even when I filled it in. I've checked the references - The query is the only thing that has a reference...

I'm using Access 2010, and I'm creating a navigational form with subforms. I have a search subform inside with multiple fields selectable by option buttons. I have the associated queries set up that would run the search in the background (and the forms would show the results of the queries)...

Hey, everyone. This is actually the first time I've used Access for an extended time. Prior to this, I would just muddle through bits and pieces. I hope I can learn lots from here! I don't know if there's really a term for it, but I'm a hobbyist programmer. I know a good amount of Visual...