BackOffice Products
cancel
Showing results for 
Search instead for 
Did you mean: 

MS Access formatting all fields

 
Piotr Kirklewski
Super Advisor

MS Access formatting all fields

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
Jesus is the King
1 REPLY 1
Roger Faucher
Honored Contributor

Re: MS Access formatting all fields

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

Roger
Make a great day!

Roger