Parameter Query Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
SELECT [Migration Table].[Record No], [Migration Table].Status
FROM [Migration Table]
WHERE ((([Migration Table].Status)=[What Status?]));

Thanks!

KARL DEWEY said:
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.

DonnaS said:
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.
Click to expand...
Click to expand...
 
Is your status field a number and are you entering text in response to the
prompt What Status?

This combination will give that error.


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

Thanks!

KARL DEWEY said:
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.

DonnaS said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.

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

This combination will give that error.


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

Thanks!

KARL DEWEY said:
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.
Click to expand...
Click to expand...
Click to expand...
 
A combobox can have several columns, displaying text but storing numbers in
the table.

Check the field property in the table.

DonnaS said:
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.

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

This combination will give that error.


DonnaS said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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?

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

Check the field property in the table.

DonnaS said:
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.

KARL DEWEY said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.

DonnaS said:
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?

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

Check the field property in the table.

DonnaS said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top