Simple Query Error

[ronquart]

I am creating a simple query on one table and I keep getting "The setting you entered isn't valid for this property." error message. After I click OK the query seems to run properly. I can't figure out what I am doing wrong....


I have Field: Rates.*
and Table: Rates

and Field: File_Number
and Table Rates

listed and the Show: box is checked on the Rates.* column

and Criteria: 743 under the File_Number with the Show box not checked.

I tried to post a screenshot but I don't have permission to post an attachment....

Any insight would be appreciated. Thanks!

Ron

 

[Joe4]

Try changing your query to SQL View, and copy and post the resulting SQL Code here.

 

[ronquart]

Here is the SQL Query

SELECT Rates.*
FROM Rates
WHERE (((Rates.File_Number)=743));

 

[Joe4]

What is the Data Type (in your Table Properties) for the File_Number field?
Do you have any errors, blanks, or weird entries in this File_Number field?

 

[ronquart]

It is showing a Data Type of Number. I will check the table to see if all 2.5 million + rows match that data type.

 

[xenou]

The setting you entered isn't valid for this property.

This doesn't sound like it's related to the query you posted, as far as the SQL goes (and it seems the query actually does work after you click okay). I'd recommend you rebuild the query from scratch. Also, is this a query by itself or are you doing something else (such as building a form or report? -- if so the problem is probably something else).

 

[ronquart]

This is a query that I made from scratch. It is not a saved query.

 

[xenou]

Did you rebuild the query from scratch as suggested? Still getting the error or not?

 

[ronquart]

Yes, it happens every time I build the query.

 

[Joe4]

Can you open the Table directly without any errors?
If you get errors trying to open the Table, then the issue is not with the Query but rather with the Table itself. Maybe you have some bad data on errors in certain fields.

If you can open the Table without problems, try running this query and see if it works.

[COLOR=#333333]SELECT Rates.[/COLOR][COLOR=#333333]File_Number[/COLOR]
[COLOR=#333333]FROM Rates[/COLOR]
[COLOR=#333333]ORDER BY Rates.File_Number;[/COLOR]

This simply creates a query that only returns the File_Number field, and sorts by it.
Check the first and last records in that query to make sure they don't look funny.