Hi,
You helped me out in the right direction anyway!
I started to look for a similar funcion in Access and found the answer there.
In case you (or anyone) is interested, here is the solution:
Select tblprodukt.produkt_id, IIF(produkt_påtilbud, produkt_tilbudspris, produkt_pris) AS salgspris...
Hi again... i'm sorry to bother you so much, but i have been struggling with this problem for days.
Yes, i meant Boolean. And Yes, it is an Access database, but i use the VB designer to write SQL lines, so i thought i had to find the answer in an SQL forum.
I still get the same error, but i...
Hi,
Table name: tblProdukt
Column names: Produkt_Pris (text format, this is the normal price) , Produkt_ TilbudsPris (text format, this is the special offer price) , Produkt_PåTilbud (boolean to indicate wheter the produkt is on sale or not)
Thanks again! Peter
Hi,
Thanks for answering my question!
I entered the sql line exactly in the VB designer, but i get an error (if i enter the line literally i get: erroe in SELECT clause: expression near 'boolean' Unable to parse query text.
Can you help me out here?
Hi,
I have a Produkt table with 2 prices (ordinary price and special offer price) in the table there is also a boolean which determines if the produkt is on sale or not.
Now i want to write an SQL line that pulls out the Special Offerprice when the boolean is true.
I understand that i need...
Hi,
I let the user input a date in the calender dirct-x control, but i want to format the date to a long date (f. ex. 10 oktober 2002) but when i use cdate(date), then i get 10.10.2002 as ouput.
Can somebody help me out here?
Thanks in advance, Peter
Actually this is a reply to the 2 mails from juli. I have exactly the same problem and i wonder what to do?
Arent the Frontpage Server Extensions installed automatically when you install IIS 5.1?
Regards, Peter
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.