try this:

=DSum("QuotesTotal", "Employees") + 1

--
Ken Snell
<MS ACCESS MVP>

"AIS_DBA" <tdandeneauaisequip.com> wrote in message
news:0d9601c346f6$ea9924f0$a501280aphx.gbl...
> Hi - I'm new to Access, and all self taught - I'm use to
> Lotus notes. I need help:
>
> This sould be a simple little counter for our receptionist
> to increment the count of number of faxes that come in to
> our central fax machine for our salesmen, by clicking on a
> button.
>
> I have a "Employees" table with five fields:
>
> EmployeeID - Autonumber
> First Name - Text
> Last Name - Text
> Quotes Total - Number (LI - new values Increment)
> Sales Total - Number (LI - new values Increment)
>
>
> I have a form. I want to be able to increment Quotes Total
> and Sales total by one by clicking on a button.
>
> In my On Click Event I have:
> =SUM(Employees![QuotesTotal]+1)
>
> I get the error-
>
> The expression On Click you enetered as the event property
> produced the folllowing error. The object doesn't contain
> the automation object 'Employees.'.
>
> What am I doing wrong?
>
>
> Any help would be appreciated. The MS knowledge base
> wasn't much help.
>
>