MS Access formatting all fields

[Piotr Kirklewski]

Hi there

Not sure if this is the right forum but could not find anything specfic to MS Office.

I know how to format a single field in MS access:

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

[Roger Faucher]

I think your best bet will be http://support.microsoft.com/

Roger