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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ridsey

  1. ridsey

    Microsoft Access IIF Statement

    Nevermind, was able to figure it out myself!
  2. ridsey

    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...
  3. ridsey

    Problems with date formats

    dont worry about it, i got it workin, just a stupid mistake on my part! thanks very much for the help! ridsey
  4. ridsey

    Help with the following code:

    Nevermind, i got it work, just a stupid mistake on my part! thanks again crazybird for the help, i really appreciate it!
  5. ridsey

    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))...
  6. ridsey

    Problems with date formats

    Thank you for your help, Im not that familiar with lotus123, so this may sound stupid, but do i put this in the top row and copy downwards, or do i need to put this code somewhere else? I guess i'm just wondering if this will convert all 5000 rows i have at once. Thanks again Ridsey
  7. ridsey

    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...
See more

Part and Inventory Search

Back
Top