Assign Query Result To Avariable

[ahd2008]

I know how to use queries but what if there is a button on a form that use a query to assing the result to a value?

For example

this query will gives the totall of the all employees whish is 5

SELECT Count(*) FROM Employees;

I want to use this query throw a from to assing the result to a variable, For instance:

Dim x as Integer

x= ???

can anyone advise how to assing the query to X ?

[ChipR]

Check out the DCount function, among others. DLookup is also very useful.