If then Query

[rowk]

Hi there,

I have a pretty stupid question - brian is not working today.

I have a col that has # of eggs - I'm trying to write a query that will add a col with the following in it:
3 or less - "Group 1"
between 4 and 30 - "Group 2"
between 31 and 300 - "Group 3"
greater than 300 - "Group 4"

I think i'm just thinking about it too much.

Any help would be greatly appreciated.

Row

 

[Andrew Fergus]

Hi Row

Try something like this :

Iif([Num_Eggs]<4, "Group 1", Iif([Num_Eggs]<31, "Group 2", Iif([Num_Eggs]<301, "Group 3", "Group 4")))

But remember to use your actual variable name where I have used [Num_Eggs]

HTH, Andrew.

 

[rowk]

Thanks for that Andrew,

Will the formula you've given take into account the group two perameter being between 4 and 30 - or will it just take everything <31?

Eggs can be a messy business.

 

[Andrew Fergus]

Hi

Eggs can be a messy business.

I know - I used to work on a chicken farm many moons ago ..... it put me off eggs and chicken for about a year.....

Will the formula you've given take into account the group two perameter being between 4 and 30 - or will it just take everything <31?

The formula reads from left to right, for values less than 4 it will return "Group 1" and the <31 bit won't come into it and so on.

Give it a try - the worst that can happen is that it won't work - although it should.

HTH, Andrew.

 

[rowk]

You are a legend!! Thanks for that!