Search results

can someone pls help me with this..thx..

u mean put both conditions in 1 bracket?? Like IIf(A < Field B,field A < Field C,Field B + Field C ,Field A + Field C) AS Z Is this what u mean? Thanks..

I should have mentioned that because the value of my calculated field changes as it satisfies aan expression I create a new field.But in my form I want to show only one control for all these field that are affected.If the expression satifies field X then Field X should be shown in this partcular...

I have this query which selects two fields and calculates it in another field. But the calculated field has more than 1 expression.Eg If field A < Field B,Field B + Field C AS X,If field A < Field C,Field A + Field C AS Y.The problem is that when I show this on the Form I want only 1 of the...

I want to change the column name after I have run my select query.The column name is currently expr1001.How can I do this?? Thanks

its more like I pasted the data from excel.

But the problem is that this table I imported it from excel.When changing the structure I have to look at each employee and see which deductions code is being deducted.What if there is a lot of employees, doing this will be time consuming.What do u think???

so i need to use a query to make my table normalised right??

thanks i wil....

I have this employee table that have column names - Name,Job description,etc and Deduction1,Deduction2....... DEDUCTION 22. Table looks something like this: Name Job Descript Deduction1 Deduction2 Deduction3 Peter Clerk $10 $0 $2 I want to show...

can anyone help me please..

how do we create an executable file of a form with only the form showing and the access window grayed out.

form entry ok.but now i want to add a new customer in my form and i want my table to show this new entry.how do i do that?

Iam trying to add a new entry in a table using a form.iam a newbie in ms access.can someone pls help me...