Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: If statment to asp ??

    I have a statement written in access query and I want to convert it to be applied on SQL Database or on ASP.Net
    Access Statement:
    Toal paid : IIf([TP$]>0,(Format([TP$],'Fixed') & ' $')) & IIf([TPU]>0,(Format([TPU],'Fixed') & ' Euro')) & IIf([TP$]+[TPU]=0,0)

    The result is a column as following

    30 $
    250 Euro
    20 $

    How I can apply it in

  2. #2
    Join Date
    Jun 2003
    Well don't forget that you can do calculations and formating in code that does not actually reside in the actual SQL statement. And yes Access is handy in that you can use IIf() within a SQL statement.
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts