query help

[hayden]

I have gone into query design and want to know what function i use so that if value =1 in my table that it changes to so that grass is displayed

 

[pbaldy]

Try an IIf() function.

 

[hayden]

tried doing that put =IIf([surface type]=1,"grass",0) but didnt work :-/

 

[pbaldy]

In a query you wouldn't want the "=". In design view it would look like:

PickAnyName: IIf([surface type]=1,"grass",0)

 

[hayden]

what does the PickAnyName: mean because copied pasted in and came up with an error message saying
you may have entered an invalid identifier ir typed parenttheses following the null constant

highlighting the first bracket?

 

[pbaldy]

PickAnyName is simply an alias; it can be anything that you want it to be. Where exactly did you put it? It was intended to be a new field in a query in design view.

 

[hayden]

i did not put it in a new field, i have now put it in a field but it comes up with up with #Error

 

[pbaldy]

Can you post the db?