output sqlcommand in variable

[rjumelet]

I want to put the output of a count-command in variable, what is the way to achieve this ?
First make a table, set the output in a row and select it. There must be a easier way.

thanks in advance

Rob

 

[jrbarnett]

Either use: variable = DCount ("*", "Tablename or queryname&quot

or put this as a controlsource on a form or report.

You can add an optional restriction clause after the table or queryname to restrict it further.

variable = DCount ("*", "Tablename or queryname", "animal='cat'&quot

John