Many Years

[pgalvezt]

I have many years in my database.

So I put

Table:

Load

Year

Monh

Resident TT

Where Year 2010 And Year 2011

Order By Month

Year goes 0.

With Or just show 2010

Thanks.

[MayilVahanan]

Hi,

     Try like this,

Edit:

Use or instead of and

Load

Year

Monh

Resident TT

Where Year = 2010 or Year = 2011;

Hope it helps

[#3]

did You write?

where Year=2010 or Year=2011

i believe this should work...

[pgalvezt]

where Year=2010 or Year=2011

Just bring me 2010

[MayilVahanan]

Hi

     Can you check load once and check whether year = 2011 available?

[#6 · Accepted solution]

reverse the where statement and tell us what is the result

where Year=2011 or Year=2010

[#7]

hmmm interesting...

reversing 2010 and 2011 fix the problem?

[pgalvezt]

Yes, very wire because I reloaded the model again and fix the problem. Any case many thanks.

[whiteline]

Cool.

Could you try also where (Year=2010) or (Year=2011)

[pgalvezt]

Ok! Thank you for your advice.