Search results

I am trying to build a IIf function in my query (is it appropriate in query) to compare two fields A1 and A2 to get the lower value one. can any one told me how to build it. i try MS help but it did not work out. Thank you very much.

Thanks, could you give me a little detailed information how to perform the control. have a nice day.

I built a subform in a switchboard. the subform is related to a regular form. the problem is that when i click the drop down menu in the subform combo box, the value did not show in the text box, but in the regular form, there is no problem. can anyone help me on this. Thank you very much...

NO. i used the toolbox to put a combo in the form and then tried to change the properties and link to a table.

No, i used design view.

I tried to build a drop down menu which linked to table, but when i change to datasheet view, and click the dropdown menu arrow, it was blank. i can only get the value from the forward/backward arrow bar in the form bottom, not from the dropdown menu arrow. Could anyone help me on this? a...

thanks, a little detail thank you very much for your information. could you give me detail or instructions how to perform it. i am a beginner on access. Have a nice day.

:) If i have a data base with 10 companies and for each compnay there are 10 products, i need to generate 100 report to cover all. Does anyone know if it is possible to build a kind of switchboard, where i can use a drop down menu for company and another down menu for product, then i just click...