Book Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word? Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word ![]() ![]() Host your Web site with PureHost! ![]() |
![]() ![]() Sunday, July 26, 2009 – Permalink – Fiscal Year in AccessMake up your own yearYou can show a custom Fiscal Year starting June, 1 and ending May 31. BeginFiscalYr = DateSerial(Year(Date), 6, 1) EndFiscalYr = DateSerial(Year(Date) + 1, 6, 1) - 1 Also: Calculating a future or past date in Access See all Topics access <Doug Klippert@ 3:29 AM
Comments:
Post a Comment
Saturday, September 13, 2008 – Permalink – Make Null ZeroIt's nothingWhen it is desirable to return a zero (or another value) rather than an empty field, Access (Visual Basic) has a function Nz(): Nz(variant, [valueifnull])
When you want to display zeroes in text boxes (or datasheet columns) when there is no value in a field, the standard method is to surround the value with the Nz() function, to convert a Null value to a zero. However, this doesn't always work, especially in Access 2003, which is much more data type-sensitive than previous versions. In these cases, you can force a zero to appear instead of a blank by using two functions: first Nz() and then the appropriate numeric data type conversion function, such as CLng or CDbl. Here is a sample expression that will yield a zero when appropriate: ACCESS Watch Vol 7 No. 5 See all Topics access <Doug Klippert@ 3:32 AM
Comments:
Post a Comment
Thursday, August 28, 2008 – Permalink – Calculate AgeA few solutionsHere are some methods that have been posted to the newsgroups: Assuming that the birth date field is called [BDate] and is of type date, you can use the following calculation:
Alternately you can use this function to calculate age: From: <Doug Klippert@ 3:03 AM
Comments:
Post a Comment
Saturday, March 29, 2008 – Permalink – Week NumbersWho's counting?For most purposes, weeks are numbered with Sunday considered the first day of the week. This works most of the time, but it can be a little confusing certain years.
If your week starts on a different day, you can use the Analysis ToolPac function:
"The function WEEKNUM() in the Analysis Toolpack addin calculates the correct week number for a given date, if you are in the U.S. The user defined function shown here will calculate the correct week number depending on the national language settings on your computer."
datepart("ww",[DateField],7,1)
<Doug Klippert@ 7:23 AM
Comments:
Post a Comment
Saturday, September 01, 2007 – Permalink – Total FooterSum() it up
<Doug Klippert@ 7:50 AM
Comments:
Post a Comment
Monday, April 23, 2007 – Permalink – Numbers to WordsCardinal numbersYou can create a User Defined Function in Access to covert numbers to words. The function can be used in a calculated field or control in a form or report. From the Microsoft Knowledgebase collection: How to Convert a Numeric Value into English Words - 210586 ![]() Also: The Access Web (MVPS) Convert Currency ($500) into words (Five Hundred Dollars) TECH on the Net.com Convert currency into words (The Access code also works in Excel) To create Cardinal numbers in Excel see: Excel - Numbers to Words (The Excel code also works in Access) Word appears to be the only Office app with a built in cardinal number function. For Word see: Word - Numbers to Words See all Topics access <Doug Klippert@ 5:15 AM
Comments:
Post a Comment
|