RE: [AccessDevelopers] column lookup

[Jones, Glenn P MSG (Ret) FL-ARNG]

Title: Message





Personally Correct,
 
If 
cboTerm and cboType are you drop down boxes
 
I 
would consider the dLookup() function.
Something like:
Cost = 
dLookup("cboType", "table name", "Term Length = cboTerm")
Assuming you have an effective date of policy to base your termination 
date on i.e. PolicyDate:
Termination Date = IIF([cobTerm] = "Annually", DateAdd("y", 1, 
[PolicyDate]), IIF([cboTerm] = "Semiannual", DateAdd("m", 6, [PolicyDate]), 
IIF([cboTerm] = "Quarterly", DateAdd("m", 3, [PolicyDate]), IIF([cboTerm] = 
"Monthly", DateAdd("m", 1, [PolicyDate]))))
 
Double 
check syntax but the logic should be sound.
 

MERRY 
CHRISTMAS and HAPPY NEW YEAR TO 
ALL

Glenn P. Jones
IHS
 

  
  -----Original Message-----From: 
  AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] 
  On Behalf Of DRRSent: Tuesday, 20 December, 2005 
  20:10To: AccessDevelopers@yahoogroups.comSubject: 
  [AccessDevelopers] column lookup
    
  Hi 
  All:
   
  I realize this 
  next question is going to sound awfully simplified for this group considering 
  I've been working w/Access for over a year BUT....I believe Alzheimer's is 
  setting in and I can't seem to "get" how to do this.  Here's is an 
  example.
   
  Table1:   members
  Table2:   contracts
  Table3:   plandetails
   
  Here 
  goes:   
   
  1). I have a form 
  that uses "contracts" as it's default table. I have 2 drop down 
  boxes. 
  2). box 
  1 drops down the plan type ie:  standard, family, senior 
  etc.
  3). box 
  2 drops down "term length" ie:  annual, semi-annual, quarterly, 
  monthly etc.
  4). There are 2 
  fields I need updated. (cost & expiration Date).
  4). I have a table 
  that has plans as rows and key, name, annual cost, semi annual cost, quarterly 
  cost etc as columns.
   
  I would like to 
  chose a "plan" from box 1 and a "term" from box 2 and have TWO fields updated 
  in the contract table. Field one would be cost field two would be expiration 
  date. I am able to get one or the other but not sure how to get BOTH? I guess 
  what I'm asking is if they drop down "senior member" and "annual" how can I 
  get the form to know "semi-annual" is the fourth column in the table 
  "plancosts". (The drop down box selcts the proper "row" but How can I select a 
  column in that row).
   
  I'll stop here 
  because I'm confusing myself let alone anyone trying to interpret this. Thanks 
  for ANY suggestions. 
   
   
  +=============+
  Politically Correct is  
  
  Personally Incorrect
  +=============+
   
  --No virus found in this outgoing message.Checked by 
  AVG Free Edition.Version: 7.1.371 / Virus Database: 267.14.1/207 - Release 
  Date: 12/19/2005






Please zip all files prior to uploading to Files section.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.