PC Review


Reply
Thread Tools Rate Thread

calculating behind the scenes

 
 
f
Guest
Posts: n/a
 
      16th Sep 2003
Hi,

I have a query which gathers the following data:
calculates the number of days someone has held a
position, based on the start date and today's date. The
fields are employee_id, nbr_retention_days, startdate,
enddate, lastcontactdate (last date the employee was
contacted at their job).

The output is to a form. My question is, that now I need
the form to do the following upon opening:

List those who have been in a position at 7 days, 14
days, 30 days, 60 days and 90 days -- IF they have NOT
been contacted at least one day before they reach each of
these milestones (7 days, 14 days, 30 days, 60 days, 90
days.

Any ideas appreciated.

-f
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for Dreamscene scenes? Randor Windows Vista General Discussion 3 16th Feb 2007 08:40 AM
ado behind the scenes =?Utf-8?B?ODVhc2NNY0xhcmVu?= Microsoft Access 0 6th Mar 2006 04:01 PM
Scenes and Collections Corey Thompson Windows XP MovieMaker 7 30th Jun 2005 08:35 PM
Scenes 2 Mark Segal Windows XP Photos 1 1st Jun 2005 09:36 PM
Behind the scenes of ServiceController???? =?Utf-8?B?THVpcyBGYWphcmRv?= Microsoft Dot NET Framework 6 12th Nov 2004 02:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:47 PM.