Hi all,

I have a dbf and when i export this file with a select and copy to type xls some results are changed. for ex intead of 10 i have 1,7977E+308 how do i solve this problem so i get 10 instead of 1,7977E+308.

thnx

this is my select :

SELECT IIF(DELETED(),'Gewist','Actief') as 'Gewist', hf_nr as 'Factuur_Nr',hf_doc as 'Type_Doc',hf_klt as 'Klantnummer',hf_dat as 'Datum',df_grc as 'Groep',;
df_art as 'Artikel',df_kort as 'Korting',df_oms as 'Omschrijving',IIF((EMPTY(df_aant) or (df_aant == 0)),1,df_aant) as 'Aantal',df_vke as 'Verkoopseenheid',IIF((EMPTY(df_bakken) OR (df_bakken ==0)),1,df_bakken) as 'Eenheid',;
IIF((EMPTY(df_aant) or (df_aant == 0)),1,df_aant) * IIF((EMPTY(df_bakken) OR (df_bakken ==0)),1,df_bakken) as totaal FROM ;
f_hfpx LEFT JOIN f_dfpx ON hf_nr = df_nr INTO CURSOR qryInvoice

Afther some test i've seen that the problem is caused by the iif statment. Somebody has a solution for this problem ?