Text box Manuplation

[Jazz]

Hi Folks,


As i am new to MS access 2010, wanted to know can we manuplate 2 text box in a query with if condition.


Your help would be appreciable.


Thanks & regards
Jazz

 

[CJ_London]

queries don't have text boxes so are your text boxes in a form?

Assuming they are then you would use something along the following lines

IIF([myform].[form].myTxtBox="abc",1,2)

 

[Jazz]

Hi CJ,

Thanks for your reply.

I would like to know if u can help me in one of my project.

I m actly migrating the excel checklist to MS Access database and would required your help in getting the blue print for the same.

Thanks & Regards
Jazz