Need Conditional calculated query field to look at 3 real fields in the query. 1

[cimoli]

I have 3 real fields (number, long integer) in a query, amongst other query fields, where I would like to make a calculated field using the 3 fields.

The 3 real fields are called: SendGroupTicketToCode and SendSplinterTicketToCode and SendLineRunTicketToCode.

For a given person, he would have a number answer in one of the 3 fields. Just 1.

I would like to make a calculated conditional 4th field called SendTicketToCode.
I need this field to look into these 3 fields and use the data that is in 1 of the fields.

For example. if SendSplinterTicketCode has an answer of 9512993 and the other 2 field are blank,
then i would like SenTicketToCode to be 9512993.

Maybe this 4th field would be along these lines:
SendTicketToCode: IIf(IsNull([SendGroupTicketToCode]),something, something, something.)

thanks

 

[dhookom]

Are you stuck on your table structure where you have encoded data into field names?

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

SendTicketToCode: Nz(SendGroupTicketToCode,0)+Nz(SendSplinterTicketToCode,0)+Nz(SendLineRunTicketToCode,0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

cimoli, did you try my suggestion ?