Recent content by jennyha23

Hello friends, I have this query but I don't know what FORMAT function really does? can you please tell me what FORMAT DOES? select emp_num, total_salary, max_salary, Format(total_salary/max_salary) AS percent_sal, (line 4) Format(total_salary*.25)/max_salary AS bonus_sal (line 5) From emp...

convert a Nz from MS Access to a zero-length string. Hello, I am migrating the Access queries in SQL server views. This is a query in Access: SELECT emp_name, nz(emp_address) FRM employee Do you know how to convert this in SQL server VIEW? especially "nz".... Thanks. Jenny.

Ray, you are right. It worked with that db. But when I applied the code to my real db, with a few tables and queries to inner join are put in the Record Source, something changed. I really don't know whether it is query or parameter changes. Can you look into the code below? (the last few...

Thanks guys. It worked. However, it modified the query somehow. I don't know why? Jenny.

Hello Ray, Attached is my db. Please click on Employee2 form and look at LName, I entered your code, but it doesn' happy of anything. Thanks.

This is exactly what I am looking for. I created a form based on a few tables (query), I tried the same way as you said, but it doesn't work. don't know why. Jenny.

It doesn't work Hello ray: This is what i am looking for to do but it doesn't work. I have a form, then I added one text field and button for Column title, then I used your code, but when I view the form, and clicked on either the text column title or button column title, nothing happened. Can...

How do I do it? Can you please show me in detailed how to do it? Thanks.

Hello friends: I created a form and I want to do SORTING every time I click on Column title. Thank you very much for reading. Jenny.

this is a word doc Hello, I don't have an access db. When you open it, you'll see a word document with the format and my question. Can you create a sample one? Please help.

Hello friends, My name is Jenny. I have a school project that I can't figure it out for 1 month. It is about forms/subforms. p.s. attached is my db. Thank you very much. God bless you.

Hello friends, My name is Jenny. I have a school project that I can't figure it out for 1 month. It is about forms/subforms. p.s. attached is my db. Thank you very much. God bless you.

Hello friends, My name is Jenny. I have a school project that I can't figure it out for 1 month. It is about forms/subforms. p.s. attached is my db. Thank you very much. God bless you.