Search results

  1. N

    Min and Max

    Hi everyone, I have a field name RefNo, RevNo check the picture below: what I want is display "LT" if Latest and "SS" if obsolete. This is the formula that Im trying to get the result I want Latest: IIf(Max([RevNo]=0),"LT",IIf(Max([RevNo]>1),"LT","SS")) Sorry for the explanation. Thank...
  2. N

    Custom ID Format

    hi everyone does anyone knows how to make a custom ID format that increment every time you add a new record the sample ID look like this "HCCR-SMA-CV-ST-000". hope someone can help me. thanks in advance!
  3. N

    Exclude Records for printing

    hi everyone just want to ask on how to exclude a record based on the value of listbox by selecting the record that i dont want to appear in the report.. the listbox is connected to a table.. thanks in advanced
  4. N

    Automatically finds the open record and insert todays date

    Help.. I just want to ask how to add code in a form that will automatically finds the open record and insert today's date? Thanks hope someone can help me..
  5. N

    Salary Adjustments

    Hi everyone.. just want to ask on how to make a history like for example i have a table of salary of all the employee.. i just want to know how to update the salary of each employee but store the old salary for tracking purposes.. do i need to make a separate table for the old record? thanks in...
  6. N

    Export Table in Excel Workbook with many sheets.

    Hi everyone just want to ask if anybody know how to export ms access table into excel workbook with separate sheet based on a value of field? For Example: I have One Table with three fields Name Address Company Steve a Apple John b Apple Josh c Dell Pete d Dell Pat e HP Jacob f HP Output...
Top Bottom