计算访问中的日期时间字段 [英] Calculate Date time field in access

问题描述

你好我需要计算两个Date字段之间的差异[Date&剩下的时间]。所以我必须采取一个字段[客户类型] =" Hang-Ups"并给出日期范围内每天挂断多少次的总数。任何人都可以帮我在MS Access中执行

hello I need to calculate the difference between two Date fields [Date & Time Left]. So I have to take one field [Customer Type]="Hang-Ups" and give a total number of how many hang-ups a day in a date range. can anyone help I have to do this in MS Access

推荐答案

SELECT Count(YourTable.ID) AS CountOfID, YourTable.[Cusotmer Type]
FROM YourTable
WHERE (((YourTable.[Date & Time Left])>=[Start Date] And (YourTable.[Date & Time Left])<=[End Date]))
GROUP BY YourTable.[Cusotmer Type]
HAVING (((YourTable.[Cusotmer Type])="Hang-Ups"));

这篇关于计算访问中的日期时间字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！