Re: logic and <

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 22:55:53 -0500

Is there a field for hire date? Are there business rules that describe the
method for calculating years of experience? Is there a table name and
perhaps some other field names? Could you provide about 5 sample records
with a column containing the calculated salary? 

-- 
Duane Hookom
MS Access MVP
--
"Greg" <anonymous@discussions.microsoft.com> wrote in message
news:BACE21A2-EF4B-4D98-9F23-70FFC4700B35@microsoft.com...
> Hi
>
> Im am trying to work out the following:
> Employees have a base salary of 30,000, and for each years experience they
get another 3000. However they cannot receive more than 150,000. How would I
do that in a query.
> Much appreciated

Relevant Pages

  • Re: conditional formatting in form slows down calculations
    ... table to see all dates and a filtered query to see recent dates. ... endless calculating when the form opens. ... Once it finished the calculating, ... > CF (Conditional Formatting) is a weird beast, and it can cause the strange ...
    (microsoft.public.access.forms)
  • Re: formatting a calculated number field on a form
    ... > I only used age at death as an example. ... > and heart attack, age 40 and heart attack, surgery and death, etc. ... >>bit different in that a parameter query limits the recordset before it ... I assumed that you were calculating on ...
    (microsoft.public.access.forms)
  • Re: query error
    ... "Jeff Boyce" wrote: ... The second query groups them by job number for one total time on job. ... you've already recorded start and stop times, the TaskTime value could be ... I have a specific job number that is not calculating ...
    (microsoft.public.access.queries)
  • Re: Parameter Query and Date calculations....
    ... Access is not good at determining the data types of calculated query fields, ... parameters, and unbound controls. ... Declare any parameter in your query. ... > I am calculating a future date using the DateAdd function in a query (the ...
    (comp.databases.ms-access)
  • Re: query error
    ... The second query groups them by job number for one total time on job. ... you've already recorded start and stop times, the TaskTime value could be ... I have a specific job number that is not calculating properly. ...
    (microsoft.public.access.queries)