DateDiff / DateAdd / Date查询的序列号问题？访问97 [英] DateDiff/DateAdd/Date Serial Question for Query ? Access 97
问题描述
提前谢谢你。我正在努力将所有库存物品从去年12月的b $ b提取回我的会计师4年。我知道这可以完成，但我正在画一个空白。我试过了;
DateDiff（" y"， - 4，DateIn）并收到错误
请提供任何帮助非常感谢。
Michael
这是我原来的帖子。对不起，我想问一下，如何从去年12月开始记录
，以编程方式将每个12月更改为
前4年，以允许它们要从库存中扣除税款吗？
Michael
Thank you in advance. I''m trying to pull all inventory items from December
of the previous year back to 4 years for my accountant. I know this can be
done, but I''m drawing a blank. I''ve tried;
DateDiff("y",-4,DateIn) and get errors
Please any assistance would be greatly appreciated.
Michael
This was my original post. I''m sorry, I meant to ask, how can pull records
from December of last year, programmatically changing each December to the
previous 4 years, to allow them to be dropped from inventory for taxes?
Michael
推荐答案
星期二，星期二，13 2004年1月19:25:37 -0600 comp.databases.ms-access，
" PMBragg" <下午***** @ megavision.com>写道：
On Tue, 13 Jan 2004 19:25:37 -0600 in comp.databases.ms-access,
"PMBragg" <pm*****@megavision.com> wrote:
提前谢谢你。我正在努力将所有库存物品从上一年的12月份恢复到我的会计师的4年。我知道这可以完成，但我正在画一个空白。我已经尝试过了;
DateDiff（" y"， - 4，DateIn）并且收到错误
我们非常感谢您的帮助。
<迈克尔
这是我原来的帖子。对不起，我想问一下，怎么能从去年12月开始记录
，以编程方式将每个12月改为
前4年，让他们从库存中扣除税款？
Thank you in advance. I''m trying to pull all inventory items from December
of the previous year back to 4 years for my accountant. I know this can be
done, but I''m drawing a blank. I''ve tried;
DateDiff("y",-4,DateIn) and get errors
Please any assistance would be greatly appreciated.
Michael
This was my original post. I''m sorry, I meant to ask, how can pull records
from December of last year, programmatically changing each December to the
previous 4 years, to allow them to be dropped from inventory for taxes?
烹饪书籍嗯？ < g>
DateDiff（" yyyy"， - 4，DateIn）
-
A）bort， R）etry，I）用大锤敲击。
Cooking the books eh? <g>
DateDiff("yyyy",-4,DateIn)
--
A)bort, R)etry, I)nfluence with large hammer.
Trevor，
这个没用，我没有记录，我的库存超过4年b
年。我也想从12月开始检查。我该怎么做？
Michael
Trevor Best <摇椅@本地>在消息中写道
news：ag ******************************** @ 4ax.com ...
Trevor,
This didn''t work, I get NO records and I have inventory that is older than 4
years. I also want to check since December. How do I do that?
Michael
"Trevor Best" <bouncer@localhost> wrote in message
news:ag********************************@4ax.com...
2004年1月13日星期二19:25:37 -0600 comp.databases.ms-access，
" PMBragg" <下午***** @ megavision.com>写道：
On Tue, 13 Jan 2004 19:25:37 -0600 in comp.databases.ms-access,
"PMBragg" <pm*****@megavision.com> wrote:
提前谢谢你。我正在努力将所有库存项目从上一年12月的b $ b回到我的会计师的4年。我知道这可以
bedone，但我正在画一个空白。我已经尝试过了;
DateDiff（" y"， - 4，DateIn）并且收到错误
我们非常感谢您的帮助。
<迈克尔
这是我原来的帖子。对不起，我想问一下，怎样才能从去年12月开始提取
记录，以编程方式将每个12月份更改为前4年
，以允许他们从库存中扣除税款？
Thank you in advance. I''m trying to pull all inventory items from Decemberof the previous year back to 4 years for my accountant. I know this can bedone, but I''m drawing a blank. I''ve tried;
DateDiff("y",-4,DateIn) and get errors
Please any assistance would be greatly appreciated.
Michael
This was my original post. I''m sorry, I meant to ask, how can pull recordsfrom December of last year, programmatically changing each December to theprevious 4 years, to allow them to be dropped from inventory for taxes?
烹饪书籍嗯？ < g>
DateDiff（" yyyy"， - 4，DateIn）
-
A）bort，R）etry，I）用大锤子冲击。
Cooking the books eh? <g>
DateDiff("yyyy",-4,DateIn)
--
A)bort, R)etry, I)nfluence with large hammer.
2004年1月14日星期三10:15:01 -0600 comp.databases.ms-access，
" PMBragg" <下午***** @ megavision.com>写道：
On Wed, 14 Jan 2004 10:15:01 -0600 in comp.databases.ms-access,
"PMBragg" <pm*****@megavision.com> wrote:
特雷弗，
这没用，我没有记录，我有超过4年的库存。我也想从12月开始检查。我该怎么做？
Trevor,
This didn''t work, I get NO records and I have inventory that is older than 4
years. I also want to check since December. How do I do that?
你能发帖查询的SQL吗？
-
A）bort，R）etry，I）用大锤子撞击。
Can you post the SQL of your query?
--
A)bort, R)etry, I)nfluence with large hammer.
这篇关于DateDiff / DateAdd / Date查询的序列号问题？访问97的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
