Query to pull a infor from a combo box and if not selected pull all records

[desnyder]

I am a real rookie, so I was not sure how to word the Title

I want to run a report and be able to select the status of employees or if need run the report to show All Records.
I have been trying a combo box (and list box), I don't know how to select all records if I don't want to filter for "Active" or "Inactive"


I have found many different articles on it, but they all assume I understand SQL or VBA, I am not totally useless, but I need some basics.

[June7]

Are you using a dynamic parameter query?

SELECT * FROM table WHERE field LIKE [input here] & "*";

[input here] can be reference to combobox or textbox.

SELECT * FROM table WHERE field LIKE Forms!formname.comboboxname & "*";

Or use VBA, review http://allenbrowne.com/ser-62.html

[desnyder]

June7 - I wish I knew what a dynamic parameter query was - If I did I probably could figure this out. I know how to add the combo box and tell it to look for the "Active" or "Inactive" and that works fine, just don't know what to modify the Combo box to tell it to show me all records if I don't select either option. Sorry, but as I said on my intro, I am new to databases

[June7]

Dynamic parameter query is a query that has variable input either by prompting user for input, as shown in my example with [input here], or by referencing a control on form, as shown in second example. As opposed to static criteria like: SELECT * FROM table WHERE field = "Active";


Did you try either? This is really quite basic Access functionality. Have you studied an introductory tutorial book?

[desnyder]

June7 - Thank you
I appreciate you at lest responding, I will try to get this figured out.
No I have not studied a tutorial book, I am retired from the Military and have a civilian job now and trying to build a database to help me and my team with some things. I have little experience or knowledge, I didn't know I was expected to have any level of understanding to post questions, I will figure it out on my own.

[June7]

Well, I would hope you have some understanding of basics of relational database concepts and Access functionality. You could really benefit from a solid week with a tutorial. Are you familiar with Access query designer? The SQL statements I showed can be built with the designer.

[desnyder]

June7 -
Once again, thanks for taking the time to respond.
I was able to manipulate the default query SQL with your suggestion and It appears to be working.

SELECT [HR Report Employee Master].LastName, [HR Report Employee Master].CurrentStatusDescription, [HR Report Employee Master].HireDate
FROM [HR Report Employee Master]
WHERE ((([HR Report Employee Master].CurrentStatusDescription) Like [Forms]![frm_EmployeeDetails]![ComboStatus] & "*") AND (([HR Report Employee Master].HireDate) Between [forms]![frm_EmployeeDetails]![StartDate] And [forms]![frm_EmployeeDetails]![EndDate]));