Number of fields within a table

Hi there,

Is there a way (function) to check the number of fields in a table by a query?

Thanks for any reply,
--
John
The Netherlands

Try:
dbEngine(0)(0).TableDefs("MyTable").Fields.Count

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John Palm" wrote in message
...
Hi there,

Is there a way (function) to check the number of fields in a table by a
query?

Thanks for any reply,
--
John
The Netherlands