Search results

  1. J

    format function - please help

    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...
  2. J

    convert a Nz from MS Access to a zero-length string.

    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.
  3. J

    sort when click on column title

    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.
  4. J

    subforms/forms help please

    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.
  5. J

    forms/subforms 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.
  6. J

    MS Access FORMS/SUBFORMS HELP PLEASE

    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.
Back
Top Bottom