Change My Data Please!!!

[Guest]

In Report:

I have two field in a report bounded from a table (Note: particular and
types is a field)
eg particular = A
Types = 1

Particular = B
Types = 2

Particular = C
Types = 3

Question:
expression =Trim([Particular] & [Types])

In the report i want : when the [Particular] is A, the [Types] is "1"
when the [Pacticular] is B, the [Types] is
"Null"
when the [Particular] is C, the [Types] is
"3"

In short, i dont want to see any values in certain [Types] when i choose
certain [Particular]

Any Solutions?

Thanks in advance

Kennykee

 

[Guest]

=[Particular] & Str(Asc([Particular])-64)