ACCESS問題:Realtime－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

ACCESS問題

Jan 29th 2015, 10:04

欲在資料表中建立乙欄名為「訂單編號」（資料類型：文字）
其欄位之預設值如下：
="新莊-" & Year(Date())-1911 & "-" & Month(Date()) & "-"

目的為呈現如下…

訂單編號：新莊-104-1-（人工自行輸入）

求助如下…

訂單編號：新莊-104-01-（人工自行輸入）

希望在自動反應出"月"的格式，能自動在前面遞補成雙位數的月格式，請問我該在預設值中如何變更？

Recommended article: Chomsky: We Are All – Fill in the Blank.
This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions