Field format in querie

[wichtel]

Hello,

Is it possible to define field formats of Update-Queries?
In particulary, how can I define a field in the querie as decimal (28,10)?

Thanks for your help
Tom

 

[Tim L]

wichtel,

if you are using an update query then you can only change field data in a record and not the format of a record field. If you want to change the format of a field you will need to change it in the table in design view or by using VBA. If you are considering changing field formats on the fly might I suggest that you may need to reconsider the design and or operation of the database?

Tim