不知道在标准中写什么 [英] Don't know what to write in criteria

问题描述

嗨！急需24小时解决，请帮助!!!!

我被要求为销售医疗设备的公司建立信息管理系统。根据法规，公司销售的每种产品应每12个月进行一次测试。我的老板要求创建一份报告，每年提供过时产品的全部信息。在过去12个月内未经过测试的产品被称为过时产品。在标准中，我写道：

Hi! It is urgent needs to be solved in 24 hours, please help!!!!
I am asked to built an information management system for the company who sells medical devices. According to legislation each type of product sold by the company should be tested every 12 month. My boss asked to create a report which gives a full of information of outdated products each year. The products which were not tested within the last 12 month are called as outdated products. In the criteria, I wrote:

展开 | 选择 | Wrap | 行号

推荐答案

您的标准不应该是IIF它。此外，您需要tbl_testmarks作为查询的一部分（除非您的代码中的引用是一个表单并且命名约定被遗忘）。因此，您获得过时产品的标准是：

Your criteria shouldn''t have the IIF in it. Also, you need tbl_testmarks as part of your query (unless the reference in your code is to a form and the naming convention got left behind). So your criteria to just get those products which are out of date would be:

展开 | 选择 | Wrap | 行号

我没有有关你的系统的详细信息，但在我看来，m应该用双引号括起来（即m）。

I don''t have the details about your systems but it seems to me that m should be wrapped in double quotes (i.e. "m").

展开 | 选择 | Wrap | 行号

这是MS Office 2013.我试过了，但它给了我整个列表除2012日期之外的产品。


DateDiff函数显示两个指定日期之间的间隔。在我的表中，有近800条记录，其中73种产品在售出后每12个月进行一次测试。 2012年，有些产品尚未经过测试。当我按照你说塞思施罗克先生的那样输入日期功能时，我的测试日期从产品销售之日起至当前日期，但2012年测试的产品除外。


公司开始销售从2006年5月开始，查询显示2006年的记录，但我不需要。

It is MS Office 2013. I tried it, but it is giving me the whole list of products except 2012 dates.

DateDiff function shows the interval between two specified dates. in my table there are almost 800 records with 73 products each tested every 12 month after being sold. In 2012, there are some products which are not tested yet. When I typed the datediff function as you said sir Seth Schrock, i am having the test dates from the date the product sold till current date except products tested in 2012.

The company started selling from May 2006, and the query shows the records from 2006, however I don''t need that.

这篇关于不知道在标准中写什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！