IF statement condition

Bernybon

Hi, I would like to do this in a group header:

[IF([Qry."TDWeekDay"] = 1, Dimanche)]
or
[IF([Qry."TDWeekDay"] == 1, Dimanche)]

the regroupement of the group header is

[Qry."TDWeekDay"]

but this dont work.. why?

thanks

Philnext

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

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

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