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 strongm 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: soda
  • Order by date
  1. soda

    embedding an if statement

    i am trying to embed an IF statement within a control source on a text file in a report? Is this do-able? I've tried: = if [date] > #01/01/01# then "no picture" & = if ([date] > #01/01/01#, "no pic", "") not sure what to do now... Thanks, John
  2. soda

    stripping a field...

    i am looking to have a field read another one that contains both alpha & numeric values yet only pick up the numeric value... Any ideas?
  3. soda

    excel if(and formulas

    I know excel can do if(and(... formulas..&nbsp;&nbsp;My question is: are there in similar formulas for vlookup or sumif?&nbsp;&nbsp;ie sumif ( this and that are true)...&nbsp;&nbsp;vlookup ( multi condition )...&nbsp;&nbsp;?<br><br>Help & Thanks,<br>John

Part and Inventory Search

Back
Top