So 'adnavec' was 'advanced' settings....
Access will normally handle dates correctly displaying in the local format.
Does it not do the same with decimal points to commas in number fields?
If not, you could certainly replace the dots with commas as I did in two of my example append queries. However, I would just use whatever is the simplest solution for you