Access中的日期范围不起作用 [英] Date Range in Access not working
问题描述
嘿...谷歌搜索我的问题，得到了这个网站...
我是SQL的新手，并且几乎甩掉它。至于学习...
我已将字段上的格式设置为mm / dd / yy以匹配返回的数据。
我在我的标准中使用> =＃mm / dd / yy＃，是> =''＃06/30/07＃''因为我只想看到最后买的东西一年中的6个月。
一切看起来都很合适。但是，它从2005年开始返回一些项目？我已经尝试了几乎我能想到的一切......我已经发布了以下SQL的建议！在此先感谢!!!
Hey... googled my problem and got this site...
I am new to SQL and pretty much "winging it" as far as learning...
I have set the format on my field to mm/dd/yy to match the data that is returned.
I am using >= #mm/dd/yy# in my criteria, being >= ''#06/30/07#'' because I only want to see things bought the last 6 months of the year.
everything seems to look right. However, it is returning a few items from 2005? I have tried just about everything i can think of... I have posted the SQL below for suggestions!!! Thanks in advance!!!
推荐答案
$ b $嘿......谷歌搜索我的问题，并得到了这个网站...
我是SQL的新手并且非常甩掉它。至于学习...
我已将字段上的格式设置为mm / dd / yy以匹配返回的数据。
我在我的标准中使用> =＃mm / dd / yy＃，是> =''＃06/30/07＃''因为我只想看到最后买的东西一年中的6个月。
一切看起来都很合适。但是，它从2005年开始返回一些项目？我已经尝试了几乎我能想到的一切......我已经发布了以下SQL的建议！在此先感谢!!!
SELECT OAUSER_ITEM.ITEM_NUMBER，OAUSER_ITEM.ITEM_DESC，OAUSER_ITEM.ITEM_DESC_2，OAUSER_ITEM.CURRENT_COST，OAUSER_ITEM.QTY_ONHAND，OAUSER_ITEM_HISTORY.LAST_PURCH_DATE
从OAUSER_ITEM LEFT加入OAUSER_ITEM_HISTORY OAUSER_ITEM.ITEM_NUMBER = OAUSER_ITEM_HISTORY.ITEM_NUMBER
WHERE（（（OAUSER_ITEM.QTY_ONHAND）<> 0）AND（（OAUSER_ITEM_HISTORY.LAST_PURCH_DATE）> ="＃06 / 30/07&＃QUOT;））;
Hey... googled my problem and got this site...
I am new to SQL and pretty much "winging it" as far as learning...
I have set the format on my field to mm/dd/yy to match the data that is returned.
I am using >= #mm/dd/yy# in my criteria, being >= ''#06/30/07#'' because I only want to see things bought the last 6 months of the year.
everything seems to look right. However, it is returning a few items from 2005? I have tried just about everything i can think of... I have posted the SQL below for suggestions!!! Thanks in advance!!!
SELECT OAUSER_ITEM.ITEM_NUMBER, OAUSER_ITEM.ITEM_DESC, OAUSER_ITEM.ITEM_DESC_2, OAUSER_ITEM.CURRENT_COST, OAUSER_ITEM.QTY_ONHAND, OAUSER_ITEM_HISTORY.LAST_PURCH_DATE
FROM OAUSER_ITEM LEFT JOIN OAUSER_ITEM_HISTORY ON OAUSER_ITEM.ITEM_NUMBER = OAUSER_ITEM_HISTORY.ITEM_NUMBER
WHERE (((OAUSER_ITEM.QTY_ONHAND)<>0) AND ((OAUSER_ITEM_HISTORY.LAST_PURCH_DATE)>="#06/30/07#"));
我相信它可能是以下两种情况之一：
首先，OAUSER_ITEM_HISTORY.LAST_PUCH_DATE可能不属于正确的日期格式。其次，尝试删除＃06/30/07＃中的引号
I believe it could be one of two things:
First, the OAUSER_ITEM_HISTORY.LAST_PUCH_DATE might not be a set under the correct date format. Second, try removing the quotes from "#06/30/07#"
我相信它可能是两件事之一：
首先，OAUSER_ITEM_HISTORY.LAST_PUCH_DATE可能不是正确日期格式的集合。其次，请尝试删除＃06/30/07＃中的引号。
I believe it could be one of two things:
First, the OAUSER_ITEM_HISTORY.LAST_PUCH_DATE might not be a set under the correct date format. Second, try removing the quotes from "#06/30/07#"
如何更改OAUSER_ITEM_HISTORY.LAST_PUCH_DATE的日期格式?????
how do you change the date format for OAUSER_ITEM_HISTORY.LAST_PUCH_DATE?????
嘿...谷歌搜索我的问题，得到了这个网站...
我是SQL的新手并且非常甩掉它。至于学习...
我已将字段上的格式设置为mm / dd / yy以匹配返回的数据。
我在我的标准中使用> =＃mm / dd / yy＃，是> =''＃06/30/07＃''因为我只想看到最后买的东西一年中的6个月。
一切看起来都很合适。但是，它从2005年开始返回一些项目？我已经尝试了几乎我能想到的一切......我已经发布了以下SQL的建议！在此先感谢!!!
SELECT OAUSER_ITEM.ITEM_NUMBER，OAUSER_ITEM.ITEM_DESC，OAUSER_ITEM.ITEM_DESC_2，OAUSER_ITEM.CURRENT_COST，OAUSER_ITEM.QTY_ONHAND，OAUSER_ITEM_HISTORY.LAST_PURCH_DATE
从OAUSER_ITEM LEFT加入OAUSER_ITEM_HISTORY OAUSER_ITEM.ITEM_NUMBER = OAUSER_ITEM_HISTORY.ITEM_NUMBER
WHERE（（（OAUSER_ITEM.QTY_ONHAND）<> 0）AND（（OAUSER_ITEM_HISTORY.LAST_PURCH_DATE）> ="＃06 / 30/07&＃QUOT;））;
Hey... googled my problem and got this site...
I am new to SQL and pretty much "winging it" as far as learning...
I have set the format on my field to mm/dd/yy to match the data that is returned.
I am using >= #mm/dd/yy# in my criteria, being >= ''#06/30/07#'' because I only want to see things bought the last 6 months of the year.
everything seems to look right. However, it is returning a few items from 2005? I have tried just about everything i can think of... I have posted the SQL below for suggestions!!! Thanks in advance!!!
SELECT OAUSER_ITEM.ITEM_NUMBER, OAUSER_ITEM.ITEM_DESC, OAUSER_ITEM.ITEM_DESC_2, OAUSER_ITEM.CURRENT_COST, OAUSER_ITEM.QTY_ONHAND, OAUSER_ITEM_HISTORY.LAST_PURCH_DATE
FROM OAUSER_ITEM LEFT JOIN OAUSER_ITEM_HISTORY ON OAUSER_ITEM.ITEM_NUMBER = OAUSER_ITEM_HISTORY.ITEM_NUMBER
WHERE (((OAUSER_ITEM.QTY_ONHAND)<>0) AND ((OAUSER_ITEM_HISTORY.LAST_PURCH_DATE)>="#06/30/07#"));
不要在你的约会日期前加上（"）引号。
（（OAUSER_ITEM_HISTORY.LAST_PURCH_DATE）> =＃06/30/07＃））;
如果您在Access中的查询构建器中工作，则不需要包含＃符号，Access将自动包含它需要。
Don''t put (") quotes around your date.
((OAUSER_ITEM_HISTORY.LAST_PURCH_DATE)>=#06/30/07#));
If you are working in the query builder in Access you don''t need to include the # signs, Access will include automatically if it needs.
这篇关于Access中的日期范围不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
