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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: base836ball
- Order by date
-
using IIF and the AND statement
Ok i just ran a test and when i get rid of the [Stock] = 1799514 AND the date then works. so my code looks like this iif([Date] >= #11/09/2005#, [Hauling]+[Storage]+[Additional]+[Towing]+4.5, [Hauling]+[Storage]+[Additional]+[Towing]+2.5) Now how do I get the Stock lol- base836ball
- Post #4
- Forum: Microsoft: Access Other topics
-
using IIF and the AND statement
That makes everything but 1799514, 2.5. I guess the date is the problem. I will fool with it, see what i can do.- base836ball
- Post #3
- Forum: Microsoft: Access Other topics
-
using IIF and the AND statement
OK what I have is a date field and a total field(which adds the total of 3 other text fields) What I am trying to do is if stock # is 1799512 then only add 2.5, and if the date is between 9/9/2005 and 11/9/2005 add 2.5, and if greater than 11/9/2005 then add 4.5. Here is what I have...- base836ball
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
