Prev: export query with formulas to excel
Next: Using a Password With an SQL IN Clause
From: neetkleat on 19 Apr 2010 14:08
I have 2 tables:

Table 1 = Position Names
PositionID - Data Type = AutoNumber
Position Name - Data Type = Text

Table 2 = Staff Positions
StaffID - Data Type = AutoNumber
Last Name - Data Type = Text
First Name - Data Type = Text
Position Name - Data Type = Number, Display Control = Combo Box, Row Source
Type = Table/Query, Row Source = SELECT [Position Names].PositionID,
[Position Names].[Position Name] FROM [Position Names] ORDER BY [Position
Name];

I am trying to create a query that will show the Last Name and First Name of
all staff who hold the position "General Staff".

Unfortunately when I try to use the combo box Position Name from the Staff
Positions table, it says there is a Data type mismatch, since under criteria,
I wrote in "General Staff".

I understand that it is a number since it is a combo box, but how do I get
it to query the Staff Positions table?

(Please let me know if you need any more details, I know that wasn't the
most clear description)
From: KARL DEWEY on 19 Apr 2010 14:15
You form that the criteria combo is on must be open and a selection made or a
default applied. For criteria referer to the combo in this manner --
[Forms]![YourCriteriaFormName]![ComboName]

You would open the form and select "General Staff" in the combo and then run
the query, either directly or by opening a dispaly form or report.


--
Build a little, test a little.


"neetkleat" wrote:

> I have 2 tables:
>
> Table 1 = Position Names
> PositionID - Data Type = AutoNumber
> Position Name - Data Type = Text
>
> Table 2 = Staff Positions
> StaffID - Data Type = AutoNumber
> Last Name - Data Type = Text
> First Name - Data Type = Text
> Position Name - Data Type = Number, Display Control = Combo Box, Row Source
> Type = Table/Query, Row Source = SELECT [Position Names].PositionID,
> [Position Names].[Position Name] FROM [Position Names] ORDER BY [Position
> Name];
>
> I am trying to create a query that will show the Last Name and First Name of
> all staff who hold the position "General Staff".
>
> Unfortunately when I try to use the combo box Position Name from the Staff
> Positions table, it says there is a Data type mismatch, since under criteria,
> I wrote in "General Staff".
>
> I understand that it is a number since it is a combo box, but how do I get
> it to query the Staff Positions table?
>
> (Please let me know if you need any more details, I know that wasn't the
> most clear description)
 | 
Pages: 1
Prev: export query with formulas to excel
Next: Using a Password With an SQL IN Clause