éç¨äº
Microsoft Office Access 2003
Microsoft Access 97ã2000 å 2002
å¨ Access ä¸å¯ä»¥ä½¿ç¨
表达å¼ï¼ä»¥å¹´ä¸ºåä½è®¡ç®ä¸ä¸ªäººçå¹´é¾ãä¾å¦ï¼æ¨å¯ä»¥å¨çªä½çæ§ä»¶ä¸è¾å
¥çæ¥ï¼ç¶åå¨å¦ä¸ä¸ªæ§ä»¶ä¸æ¾ç¤ºå¨æ¤æ¥æåçå¹´æ°ã以ä¸æ¥éª¤æä¾äºå
·ä½çæä½æå·§ï¼å
æ¬å建çªä½ãæå
¥ä¸¤ä¸ªææ¬æ¡åè¾å
¥è¡¨è¾¾å¼ã
å¨âæ°æ®åºâçªå£ä¸ï¼åå»â对象âä¸çâçªä½âï¼ç¶ååå»âæ°å»ºâã
å¨âæ°å»ºçªä½â对è¯æ¡ä¸ï¼åå»â设计è§å¾âï¼ç¶ååå»âç¡®å®âã
使ç¨å·¥å
·ç®±å
çâææ¬æ¡âå·¥å
·ï¼å¨çªä½ä¸æ·»å 两个æªç»å®ææ¬æ¡ã
å°ä¸¤ä¸ªææ¬æ¡çâå称âå±æ§åå«è®¾ç½®ä¸ºâçæ¥âåâå¹´é¾âã
å°âçæ¥âææ¬æ¡çâæ ¼å¼âå±æ§è®¾ç½®ä¸ºâçæ¥æâã
å°âå¹´é¾âææ¬æ¡çâæ§ä»¶æ¥æºâå±æ§è®¾ç½®ä¸ºä»¥ä¸è¡¨è¾¾å¼ï¼
=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format( [Birthdate], "mmdd") )
åæ¢è³âçªä½âè§å¾ã
å¨âçæ¥âææ¬æ¡ä¸ï¼é®å
¥ä¸ä¸ªæ¥æï¼å¹´/æ/æ¥ï¼ï¼ç¶åæ TAB é®ã
æ¾ç¤ºå¨âå¹´é¾âææ¬æ¡ä¸çæ°åå°±æ¯ä»è¿ä¸ªçæ¥å¼å§å°å½åæ¥ææ度è¿çå¹´æ°
追é®æ主è¦æ³ç¥éDATEDIFFåDLOOKUPæ¯å¦è½å¥ç¨ï¼å¦æå¯ä»¥å¥ç¨ï¼è½ä¸è½é对æçé£ä¸ªç»ä¸ªå¥ç¨çä¾åï¼è°¢è°¢å¤§ç¥ï¼