vba formulas in access

[fairyrak]

ithis is a vba formula, but I came to an access calculated field and pasted it and couldn't create it so how do you use vba formulas in access? (and I mean plain access without having to open vba)



=DCount("[realparent]", "calamus")

[CJ_London]

it's a vba function, not a formula. As you have written it with the = sign, this is how you would enter it in the controlsource of a control on a form or report.

Or you can use it is a query

Expr1Count("[realparent]", "calamus")

I don't know if you can use it in an access web app which does not use vba - I would think you can, but you would have to try.

[ranman256]

Formulas are used in queries, except Dcount. This is used more on a form,or code. And there,i'D use Dcount("*",table).
The query itself is the count.
All formulas would be in the query as a new virtual ield.