查询未过滤正确过滤 [英] Query not filtering correctly filtering

问题描述

您好，

  我创建了一个Select QBE，其中有三个字段：Product，Rate和BPs（Rate * 10000）。当我查看/运行查询时，一切正常。但是，如果我尝试过滤值61的BPs字段以仅包含或排除它，则忽略
过滤器。当我过滤任何其他值时，一切正常。如果我将BPs字段的表达式更改为Rate * 100 * 100，则过滤效果再次正常。 

  有没有人见过这个和/或这是Access 2013的已知错误？

TIA

David Fournier

解决方案

您好

如果这不能解决您的问题，那么我建议您使用表格设计发布您的查询和示例数据。

我们将尝试制作一个在我们这边测试来重现这个问题。

如果能够发布可以重现问题的虚拟数据库，那就更好了。

我们将尽力为您提供解决问题的建议。

问候

Deepak

Hello,

   I have created a Select QBE where I have three fields: Product, Rate, and BPs(Rate * 10000) . When I view/run the query everything appears fine. But if I try to filter the BPs field for the value 61 to either include or exclude it only, the filter is ignored. When I filter for any other value everything works fine. If I change the expression for the BPs field to Rate * 100 * 100, again the filtering works fine. 

   Has anyone seen this before and/or is this a known bug with Access 2013?

TIA

David Fournier

解决方案

Hi Mohawk1df,

I try to reproduce the issue on my side on a dummy table.

all the filters working fine on my side.

below is a query output with all data.

below is output with filter.

what I did not understand ," if I try to filter the BPs field for the value 61 to either include or exclude it only."

you had mentioned that you multiply the value of rate with 10000 to calculate bps, then how you get only 61?

other thing I want to suggest you to compact and repair your database.

so if there any corruption is there in your database then it can be corrected by it.

Compact and repair a database

if that not solve your issue then I suggest you to post your query and the sample data with table design.

we will try to make a test on our side to reproduce the issue.

it is better if you are able to post the dummy database which can reproduce the issue.

we will try to provide you the suggestions to solve the issue.

Regards

Deepak

这篇关于查询未过滤正确过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！