在做access时遇到的两个问题，请大家指教！

tzf515627

1.在access中怎么将货币转化成数值，然后参与计算，用什么函数？最后又什么把数值转换成货币符号？

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

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

sea.er

1、货币类型数据可以直接参与计算2、请参阅：http://www.accfans.net/bbs/Announce/Announce.asp?BoardID=107&ID=114

Benjamin_luk

请用 SyntaxDateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])The DateDiff function syntax has these named argumentsart 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

[em06]