Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Microsoft Access IIF Statement
Im working on an inventory database. I have a column that is used to show whether the products warranty is calculated monthly or yearly. Now im trying to using queries to create some reports of total and what not. I am using this statement in the query to calculate the yearly amount on monthly...- ridsey
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Help with the following code:
I was given the following code to insert into my row to perform a date conversion, however it gives me an error, and im not too sure if im doing something wrong, or it there is a problem in the code. @DATE(@TRUNC(A1,-4)/10000+@IF(A1<=90000,100,0),@TRUNC(@MOD(A1,10000),-2)/100,@MOD(A1,100))...- ridsey
- Thread
- Replies: 1
- Forum: Office suites general discussion
-
Problems with date formats
Hi, I have 5000 rows of information that has a column with dates entered in it. The dates have been entred in the format 990920. I want to be able to convert them to the format of 09/20/1999. I understand the @DATE command, and used it to convert the date to an integer, then convert the integer...- ridsey
- Thread
- Replies: 3
- Forum: Office suites general discussion
