Currency Field in Query

[CarlM1975]

Hi all

I want to create a new field in a make table query. I want this to be a currency field that gets updated at a later stage.

I have tried Budget:0 but I do not get the decimal points, I want to use something like #,##0.00 but the syntax is wrong, does anyone know the correct way of getting 0.00 into a field without it being text.

Thanks

Carl.

 

[namliam]

Right click the grey bar above the column in your query design window, click properties.
Set the format to be what you want it to be.

Good luck