Name

[Rashid]

I have a database. In a Table "Orders" i have create two fields general customer & Regular customer. If a new customer comes i enter name manually in general customer field .when a registered regular customer comes i select from regular customer field which is a combo box whose rowsource is "customers"
In a query i create a field Dcustomer where i want if general customer enterd dcustomer name is of general customer else if i select regular customer then Dcustomer must be of Regular customer .
I use iif([general customer ]="",[Regular customer ],[general customer ])
But it is not working Please help .

 

[theDBguy]

Hi. Welcome to AWF!

Do you have a separate table for Customer data?

 

[arnelgp]

use:

Customer: Iif(IsNull([general customer ]),[Regular customer ],[general customer ])

or

Customer: [regular customer] & [general customer]

 

[jdraw]

I concur with theDBguy--What tables and relationships do you have?

 

[Rashid]

Hi. Welcome to AWF!

Do you have a separate table for Customer data?

Yes

 

[Rashid]

use:

Customer: Iif(IsNull([general customer ]),[Regular customer ],[general customer ])

or

Customer: [regular customer] & [general customer]

Thanks a lot!