Re: Find personnelIDs previous record based on date

Tech-Archive recommends: Fix windows errors by optimizing your registry

Gary,

That worked perfectly!!! I knew it could be done, I just couldn't wrap my
head around the subquery. Thanks so much, you saved me much grief.

Tim


Gary Walter wrote:
was missing ")" in Max() of subquery...

(SELECT Max(q.[Date of transaction])
FROM yurtable As q
WHERE
q.personnelID = Current.personnelID
AND
q.[Date of transaction] < Current.[Date of transaction]
AND
q.transaction = 'promotion')

Hi Timothy,

[quoted text clipped - 117 lines]

Tim

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200710/1

.

Relevant Pages

  • Re: Tefillin on Chol Hamoed
    ... Still seems odd to only wrap the head though. ... "wrapping oneself in tzitzit." ...
    (soc.culture.jewish.moderated)
  • Re: Display records based on count value of one field
    ... The subquery idea never entered my head. ... pointer to the correct forum to use.... ... you can easily build a query that has a common syntax. ...
    (microsoft.public.access.queries)
  • How to use Append Queries to add new records
    ... new problem I haven't been able to wrap my head around. ... Perhaps my problem is that I do not understand HOW append queries work. ... The Access help says "Create a ...
    (microsoft.public.access.queries)
  • Re: Views so far on the new who.
    ... >>You just can't wrap your head around the whole 1/3 the age of ... >billion, or humans *ever* developing interstellar travel, or aliens ...
    (rec.arts.drwho)
  • Witch on a Broom doll was Re: big surprise crochet stuff
    ... take one color and wrap it on your other hand on the part after the ... take second wraped ring and slip it under the `head`, ... strongly around the head so that it becomes a broom, ... HIP thread and comes out on the other side over the hip thread... ...
    (rec.crafts.textiles.yarn)