查询条件错误： [英] Query Criteria Error:

问题描述

大家好，


我正在使用查询来提取给定位置中所有文件的记录。文件位置是可能位置的下拉列表：待批准，待处理更正，已邮寄，付费。


我希望能够运行所有文件的报告待批准 ;。我使用Criteria创建了Query [FileLocation] =" Pending Approval" （完全如数据表中所示）。如果文件的位置没有更新，它可以正常工作，但我注意到如果文件的位置已被更改，它将不会出现在报告中。


示例：文件开始待批准并在报告中显示。批准者请求更正，因此我将位置更新为待定更正，并且文件将按原样从报告中删除。一旦更正文件，我将重新提交该文件以进行审批，并将文件的位置更新为待批准文件。但在此更改后，该文件将不会出现在报告上。


我不知道为什么。


有什么想法吗？


谢谢！


~Vicki

Hi All,

I am using a query to pull records of all files in a given location. The file location is a dropdown list of possible locations: Pending Approval, Pending Correction, Mailed, Paid.

I would like to be able to run a report of all files "Pending Approval". I created the Query with the Criteria [FileLocation]="Pending Approval" (exactly as it appears on the data table). If a file''s location has not been updated it works fine, but I''ve noticed that if a file''s location has been changed it will not appear on the report.

Example: The file starts out "Pending Approval'' and appears on the report as it should. The approver requests a correction, so I update the location to "Pending Correction", and the file drops off of the report as it should. I resubmit the file for approval once it has been corrected, and update the file''s location to "Pending Approval" but after this change the file will not appear on the report.

I have no idea why.

Any thoughts?

Thanks!

~Vicki

推荐答案

听起来你可能正在使用旧值，或者像拼写错误一样简单。请发布您正在使用的代码，以帮助您了解执行报告的方式。


-AJ

Sounds like you may be running off an old value, or something as simple as a typo. Please post the code you are using, to help understand how you are executing the report.

-AJ

感谢AJ！


代码由Access 2007生成：

------------------------------------------- ---------------------------

Thanks AJ!

The code is being generated by Access 2007:
----------------------------------------------------------------------

展开 | 选择 | 换行 | 行号

好的，为了确保我理解到目前为止，你给我的代码是报告的记录来源？


如果是这样的话，我想要的两件事由你运行：

1.您是否使用与c时相同的组合框设置记录的初始值（创建时）把它从一个值变成另一个值？ （检查绑定列）

2.如果1是是，则更新相同的记录，或在更新INVOICEDATA.FILELOCATION字段时创建不同的记录。


-AJ


PS为了将来参考，您应该尝试在

OK, just to make sure I understand so far, the code you gave me is the record source of the report?

If that is the case, 2 things I want to run by you:
1. Are you setting the initial value (on creation) of the record using the same combo box as when you change it from one value to another? (Check the bound column)
2. if 1 is a "Yes", then are you updating the same record, or creating a different record as you update the INVOICEDATA.FILELOCATION field.

-AJ

P.S. for future reference, you should try to post code in the

展开 | 选择 | Wrap | 行号

这篇关于查询条件错误：的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！