new table

[couz]

I want to extract data from a table, select desired rows using condition on the field and count it.

Thanks in advance.

[efen]

Welcome to the forums ...

I don't think that you have given enough information for anyone (certainly not me) to answer your question

[bruceR]

Why do you think you need a new table? Sounds like a standard find and summary report. Agreed that you have provided far too little information.