Parameter Query Error

[Guest]

I have a table that has a field called Status. Each item is either Open,
Closed, In Progress or it is blank. I wrote a query to select a status and
have the parameter [Which Status?] but keep getting this error message: This
expression is typed incorrectly or is too complex to be evaluated.

I will want to query to select one or all of the choices too.
You guys that help are the greatest.

 

[Guest]

We can not tell you what is wrong if you do not tell us what you did.

Post your SQL statement by opening the query in design view, click on menu
VIEW - SQL view, highlight, copy, and paste in a post.

 

[Guest]

SELECT [Migration Table].[Record No], [Migration Table].Status
FROM [Migration Table]
WHERE ((([Migration Table].Status)=[What Status?]));

Thanks!

We can not tell you what is wrong if you do not tell us what you did.

Post your SQL statement by opening the query in design view, click on menu
VIEW - SQL view, highlight, copy, and paste in a post.

I have a table that has a field called Status. Each item is either Open,
Closed, In Progress or it is blank. I wrote a query to select a status and
have the parameter [Which Status?] but keep getting this error message: This
expression is typed incorrectly or is too complex to be evaluated.

I will want to query to select one or all of the choices too.
You guys that help are the greatest.

 

[Guest]

Is your status field a number and are you entering text in response to the
prompt What Status?

This combination will give that error.

SELECT [Migration Table].[Record No], [Migration Table].Status
FROM [Migration Table]
WHERE ((([Migration Table].Status)=[What Status?]));

Thanks!

We can not tell you what is wrong if you do not tell us what you did.

Post your SQL statement by opening the query in design view, click on menu
VIEW - SQL view, highlight, copy, and paste in a post.

I have a table that has a field called Status. Each item is either Open,
Closed, In Progress or it is blank. I wrote a query to select a status and
have the parameter [Which Status?] but keep getting this error message: This
expression is typed incorrectly or is too complex to be evaluated.

I will want to query to select one or all of the choices too.
You guys that help are the greatest.

 

[Guest]

No it's text. The field is a combo box that pulls from a little table called
Status. That table lists Open, Closed, In Progress. The user selects or
leaves blank.

Thank you.

Is your status field a number and are you entering text in response to the
prompt What Status?

This combination will give that error.

SELECT [Migration Table].[Record No], [Migration Table].Status
FROM [Migration Table]
WHERE ((([Migration Table].Status)=[What Status?]));

Thanks!

We can not tell you what is wrong if you do not tell us what you did.

Post your SQL statement by opening the query in design view, click on menu
VIEW - SQL view, highlight, copy, and paste in a post.

:

I have a table that has a field called Status. Each item is either Open,
Closed, In Progress or it is blank. I wrote a query to select a status and
have the parameter [Which Status?] but keep getting this error message: This
expression is typed incorrectly or is too complex to be evaluated.

I will want to query to select one or all of the choices too.
You guys that help are the greatest.

 

[Guest]

A combobox can have several columns, displaying text but storing numbers in
the table.

Check the field property in the table.

No it's text. The field is a combo box that pulls from a little table called
Status. That table lists Open, Closed, In Progress. The user selects or
leaves blank.

Thank you.

Is your status field a number and are you entering text in response to the
prompt What Status?

This combination will give that error.

SELECT [Migration Table].[Record No], [Migration Table].Status
FROM [Migration Table]
WHERE ((([Migration Table].Status)=[What Status?]));

Thanks!

:

We can not tell you what is wrong if you do not tell us what you did.

Post your SQL statement by opening the query in design view, click on menu
VIEW - SQL view, highlight, copy, and paste in a post.

:

I have a table that has a field called Status. Each item is either Open,
Closed, In Progress or it is blank. I wrote a query to select a status and
have the parameter [Which Status?] but keep getting this error message: This
expression is typed incorrectly or is too complex to be evaluated.

I will want to query to select one or all of the choices too.
You guys that help are the greatest.

 

[Guest]

I'm self taught in Access over the past year and have seen that before but
didn't understand it. How do I fix this?

A combobox can have several columns, displaying text but storing numbers in
the table.

Check the field property in the table.

No it's text. The field is a combo box that pulls from a little table called
Status. That table lists Open, Closed, In Progress. The user selects or
leaves blank.

Thank you.

Is your status field a number and are you entering text in response to the
prompt What Status?

This combination will give that error.


:

SELECT [Migration Table].[Record No], [Migration Table].Status
FROM [Migration Table]
WHERE ((([Migration Table].Status)=[What Status?]));

Thanks!

:

We can not tell you what is wrong if you do not tell us what you did.

Post your SQL statement by opening the query in design view, click on menu
VIEW - SQL view, highlight, copy, and paste in a post.

:

I have a table that has a field called Status. Each item is either Open,
Closed, In Progress or it is blank. I wrote a query to select a status and
have the parameter [Which Status?] but keep getting this error message: This
expression is typed incorrectly or is too complex to be evaluated.

I will want to query to select one or all of the choices too.
You guys that help are the greatest.

 

[Guest]

Open your table in design view and look in the DataType column for that
field. It should be either Number or Text.

Then at the bottom of the display there is another part of the window with
two tabs marked General and Lookup. Click on Lookup and see what the
Display Control says.

I'm self taught in Access over the past year and have seen that before but
didn't understand it. How do I fix this?

A combobox can have several columns, displaying text but storing numbers in
the table.

Check the field property in the table.

No it's text. The field is a combo box that pulls from a little table called
Status. That table lists Open, Closed, In Progress. The user selects or
leaves blank.

Thank you.

:

Is your status field a number and are you entering text in response to the
prompt What Status?

This combination will give that error.


:

SELECT [Migration Table].[Record No], [Migration Table].Status
FROM [Migration Table]
WHERE ((([Migration Table].Status)=[What Status?]));

Thanks!

:

We can not tell you what is wrong if you do not tell us what you did.

Post your SQL statement by opening the query in design view, click on menu
VIEW - SQL view, highlight, copy, and paste in a post.

:

I have a table that has a field called Status. Each item is either Open,
Closed, In Progress or it is blank. I wrote a query to select a status and
have the parameter [Which Status?] but keep getting this error message: This
expression is typed incorrectly or is too complex to be evaluated.

I will want to query to select one or all of the choices too.
You guys that help are the greatest.