combo box complexity

[Louie]

I have a combo box on a form to look up a list of operators now keep in mind
we have 3 plants and I need to be able to look up ALL the operators, a
specific operator or grouped by "plant 1" or "Plant 2" or "plant 3"- It only
gives me the operators individually right now See below:

SELECT Organizations.OrganizationID, [Organizations].[InspectorNum] & ' -
' & [Organizations].[Company] AS Name
FROM Organizations
WHERE (((Organizations.InactiveEmp)=No) AND ((Organizations.InspectorNum) Is
Not Null))
ORDER BY [Organizations].[InspectorNum] & ' - ' & [Organizations].[Company];

 

[KARL DEWEY]

How do you plan on using the combo in this SQL? You did not put it.
What does the datalist of the combo look like?
What does the data in the field that you will apply the combo as criteria
look like?

 

[Louie]

It will run a query based on operator information using "Like
[Forms]![frmReportsArea]![qrycboOperatorSelect]" which will run a report -
the format is a** - [name].

I hope this helped.

How do you plan on using the combo in this SQL? You did not put it.
What does the datalist of the combo look like?
What does the data in the field that you will apply the combo as criteria
look like?

--
Build a little, test a little.

I have a combo box on a form to look up a list of operators now keep in mind
we have 3 plants and I need to be able to look up ALL the operators, a
specific operator or grouped by "plant 1" or "Plant 2" or "plant 3"- It only
gives me the operators individually right now See below:

SELECT Organizations.OrganizationID, [Organizations].[InspectorNum] & ' -
' & [Organizations].[Company] AS Name
FROM Organizations
WHERE (((Organizations.InactiveEmp)=No) AND ((Organizations.InspectorNum) Is
Not Null))
ORDER BY [Organizations].[InspectorNum] & ' - ' & [Organizations].[Company];

 

[KARL DEWEY]

the format is a** - [name].
What has this format?
What field relates to 'operators'?
I do not see anything in query relating to 'operators'.

I do not see anything in the query that is making a selection.

What field in the query will the combo be used as criteria on?

What does the datalist of the combo look like?

What does the data in the field that you will apply the combo as criteria
look like?

--
Build a little, test a little.

It will run a query based on operator information using "Like
[Forms]![frmReportsArea]![qrycboOperatorSelect]" which will run a report -
the format is a** - [name].

I hope this helped.

How do you plan on using the combo in this SQL? You did not put it.
What does the datalist of the combo look like?
What does the data in the field that you will apply the combo as criteria
look like?

--
Build a little, test a little.

I have a combo box on a form to look up a list of operators now keep in mind
we have 3 plants and I need to be able to look up ALL the operators, a
specific operator or grouped by "plant 1" or "Plant 2" or "plant 3"- It only
gives me the operators individually right now See below:

SELECT Organizations.OrganizationID, [Organizations].[InspectorNum] & ' -
' & [Organizations].[Company] AS Name
FROM Organizations
WHERE (((Organizations.InactiveEmp)=No) AND ((Organizations.InspectorNum) Is
Not Null))
ORDER BY [Organizations].[InspectorNum] & ' - ' & [Organizations].[Company];

 

[Louie]

the format is a** - [name].

What has this format?

[Organizations].[InspectorNum] & ' - ' & [Organizations].[Company];

I do not see anything in the query that is making a selection.
What field in the query will the combo be used as criteria on?

What does the datalist of the combo look like?

the list includes [Organizations].[InspectorNum] & ' - ' & [Organizations].[Company];>

What does the data in the field that you will apply the combo as criteria
look like?

I hope I answered the question approriately

the format is a** - [name].

What has this format?
What field relates to 'operators'?
I do not see anything in query relating to 'operators'.

I do not see anything in the query that is making a selection.

What field in the query will the combo be used as criteria on?

What does the datalist of the combo look like?

What does the data in the field that you will apply the combo as criteria
look like?

--
Build a little, test a little.

It will run a query based on operator information using "Like
[Forms]![frmReportsArea]![qrycboOperatorSelect]" which will run a report -
the format is a** - [name].

I hope this helped.

How do you plan on using the combo in this SQL? You did not put it.
What does the datalist of the combo look like?
What does the data in the field that you will apply the combo as criteria
look like?

--
Build a little, test a little.


:

I have a combo box on a form to look up a list of operators now keep in mind
we have 3 plants and I need to be able to look up ALL the operators, a
specific operator or grouped by "plant 1" or "Plant 2" or "plant 3"- It only
gives me the operators individually right now See below:

SELECT Organizations.OrganizationID, [Organizations].[InspectorNum] & ' -
' & [Organizations].[Company] AS Name
FROM Organizations
WHERE (((Organizations.InactiveEmp)=No) AND ((Organizations.InspectorNum) Is
Not Null))
ORDER BY [Organizations].[InspectorNum] & ' - ' & [Organizations].[Company];

 

[KARL DEWEY]

The selection is made from the combo box on a form and a seperate queries
runs the "cboInspectorSelect" from what ever is selected on the form then
runs a report

I can not answer a question about applying the combo differently in a query
if you do not show me that query!