Search results for query: *

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

Yes, that was exactly what i was looking for. Thanks man!

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

I have exactly the same problem! please let me know if you find out what to do