Office中国论坛/Access中国论坛

标题: 在做access时遇到的两个问题，请大家指教！ [打印本页]

作者: tzf515627 时间: 2004-8-19 16:09
标题: 在做access时遇到的两个问题，请大家指教！
1.在access中怎么将货币转化成数值，然后参与计算，用什么函数？最后又什么把数值转换成货币符号？

2.如何在access中实现日期的减法运算，运用什么函数？

小弟刚上手，还部怎么理解accsee，希望能得到大家的指导。

作者: sea.er 时间: 2004-8-19 16:14
1、货币类型数据可以直接参与计算2、请参阅：http://www.accfans.net/bbs/Announce/Announce.asp?BoardID=107&ID=114

作者: Benjamin_luk 时间: 2004-8-19 17:17
请用 SyntaxDateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])The DateDiff function syntax has these named arguments

art Description

interval Required. String expression that is the interval of time you use to calculate the difference between date1 and date2.

date1, date2 Required; Variant (Date). Two dates you want to use in the calculation.

firstdayofweek Optional. A constant that specifies the first day of the week. If not specified, Sunday is assumed.

firstweekofyear Optional. A constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs.

SettingsThe interval argument has these settings:Setting Description

yyyy Year

q Quarter

m Month

y Day of year

d Day

w Weekday

ww Week

h Hour

n Minute

s Second[em05]

作者: liurx 时间: 2004-8-19 19:32
[em06]

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)