If and then

[LEE hepworth]

What I want to do is if a field in a query Payment_Method is say dd produce another field to produce the result direct debit and if its Q in Payment_Method produce Q in the New field.
I have linked the query to a table and once this is up and running I will copy it to Excel.

But all I want is the If Statement ie If Payment_Method = DD Then Etc.....

Ta

 

[a.sinatra]

I'm a little confused, but is this what your wanting, put this on the after update of "Payment_Method"

Me.NewField = Me.Payment_Method

________
MARIJUANA VAPORIZER

 

[LEE hepworth]

Query

I'm a little confused, but is this what your wanting, put this on the after update of "Payment_Method"

Me.NewField = Me.Payment_Method

Hi
what i have is a query with a field called Payment Method. In this field there is DD and Q
What I want is to produce a new field in this query only and if the Payment Method is dd prodce Direct debit in the New Field and if Q produce Q
ta

 

[Jon K]

You can use the IIF() function:-

NewField: IIf([Payment_Method]="DD","Direct debit",[Payment_Method])