Question Insert Column and populate based on criteria

[simonharry]

HI all,

I have a DB that generates a report that contains amongst other things, country of origin.

What i need to do with this report is add in a column and in this inserted column, add either "STD" or "NIL" based on the country of origin, depending upon the tax rate that country is charged.

Can anyone help?

Thanks

Simon

 

[John Big Booty]

Welcome to the forum.

How will you determine if the tax rate is standard or Nil? Is this stored in your DB somewhere

 

[simonharry]

Cheers for the response.

What i have done is insert a new table with two columns, countries and vat code eg.

France STD
Germany STD
USA NIL

In effect i want the DB to use this table to say where the report query says the country is USA, pick NIL and place it in the cell in the new column.

Someone mentioned i could link the "country" field in my new table to the country one in the other table and then drag the VAT Code field in to make it populate but this appears to not work for me.

 

[JoanneJames]

I'd suggest doing this in your query using an iif stmt to create the extra field, so the data will be available for your report.

 

[John Big Booty]

Why not simply pick this data up in your query?

 

[John Big Booty]

I'd suggest doing this in your query using an iif stmt to create the extra field, so the data will be available for your report.

Bingo

 

[simonharry]

Result! It works. Thats for your help people, much appreciated. My boss thinks i'm a genius now! haha

 

[John Big Booty]

Result! It works. Thats for your help people, much appreciated. My boss thinks i'm a genius now! haha

Don't forget to send us a little bit of your pay rise then