format all fields of a query

[nagileon]

Hi there

I know how to format a single field:

select Format([PVP],'General Number') as PVP_ from ns_data where PVP Is Not Null;

How do I format all the fields, without listing them all ? (there is around 120 of them)

I've tried this:

select Format([*],'General Number') from ns_data;

No luck.

Regards

Peter

[RuralGuy]

120 fields in one table? I suspect a normalization issue.