Format column in combobox

[LodewijkG]

Beste Helpmij gebruikers,

Ik wil graag een column in mijn combobox de format voor euro's geven. Nu heb ik het volgende stukje:

SELECT qryFreight.FreightCostId, qryFreight.tblFreight.CountryId, qryFreight.Country, qryFreight.Departure, qryFreight.Destination, qryFreight.Time, qryFreight.ContainerSize, [Sea]+[Land]+[CAF]+[BAF]+[LSS]+[Customs]+[THC]+[ISPS]+[IMO] AS Cost, qryFreight.ValidUntill, qryFreight.Forwarder, qryFreight.ShippingLine, qryFreight.Type, qryFreight.BAF, qryFreight.CAF, qryFreight.LSS, qryFreight.THC, qryFreight.ISPS, qryFreight.IMO, qryFreight.Customs, qryFreight.FreightId
FROM qryFreight
WHERE (((qryFreight.ValidUntill)>Date()) AND ((qryFreight.Type)="Transport to destination"))
ORDER BY qryFreight.Country;

Nu wil ik de [Sea]+[Land]+[CAF]+[BAF]+[LSS]+[Customs]+[THC]+[ISPS]+[IMO] AS Cost formatten in euro's maar als ik:

Format(([Sea]+[Land]+[CAF]+[BAF]+[LSS]+[Customs]+[THC]+[ISPS]+[IMO] AS Cost),"€#,##0.00")

Krijg ik een syntax error, kan iemand mij toelichten waar ik fout zit?

 

[OctaFish]

Je veldnaam mag sowieso nooit binnen de functie staan.

SELECT FreightCostId, CountryId, Country, Departure, Destination, Time, ContainerSize,
    Format(([Sea] + [Land] + [CAF] + [BAF] + [LSS] + [Customs] + [THC] + [ISPS] + [IMO]), "€#,##0.00") As Cost
    ValidUntill , Forwarder, ShippingLine, type, BAF, CAF, LSS, THC, ISPS, IMO, Customs, FreightId
    From qryFreight
    WHERE (ValidUntill > Date And type = "Transport to destination")
    ORDER BY Country;