IF statement condition

Comments

• Philnext

  April 2004 edited 5:01PM

  what do you want to do with 'dimanche' ?
  
  The the best way is, if the variable 'jour' exists is like :
  
  if ([Qry."TDWeekDay"] = 1) then jour := 'dimanche'
  
• AzzaAzza69

  April 2004 edited 5:01PM

  Things that strike me with your 'IF' are:
  1. it is missing a parameter.
  2. if Dimanche is a variable it needs [] around it else if it is a string it needs quotes.
  
  try
  [IF([Qry."TDWeekDay"] = 1, 'Dimanche', 'Other')]
  
• Bernybon

  April 2004 edited April 2004

  i did that:
  

  wrote:

  [IF([Qry."TDWeekDay"] = 1, 'Dimanche', IF([Qry."TDWeekDay"] = 2, 'Lundi', IF([Qry."TDWeekDay"] = 3, 'Mardi', IF([Qry."TDWeekDay"] = 4, 'Mercredi', IF([Qry."TDWeekDay"] = 5, 'Jeudi', IF([Qry."TDWeekDay"] = 6, 'Vendredi', IF([Qry."TDWeekDay"] = 7, 'Samedi')))))))]:

  
  this work fine
  
  thanks for your help