Recent content by nathanmav

  1. N

    Min and Max

    arnelgp, This query: select RefNo, Max(RevNo) As RefNo , Count(1) As Expr1, Iif([Expr1]>1,"LT", "SS") As Latest from yourTable Group by RefNo;
  2. N

    Min and Max

    arnelgp, Its working and this is what i need.. Thank you very much
  3. N

    sir puno na inbox nyo d na ko mkamsg

    sir puno na inbox nyo d na ko mkamsg
  4. N

    Min and Max

    hi arnelgp, I followed your instruction and make two queries the result is what i am looking for except that is it possible to display "LT" in the latest field Thanks
  5. N

    Min and Max

    Cronk, Highest value is always the latest if 0 is the last value it should be the latest. I tried your formula and the result is different. Thanks
  6. N

    Min and Max

    theDBguy, I tried your query but i get an error of "enter parameter value of SQ.MaxofRevNo and SQ.RefNo Thanks
  7. N

    Min and Max

    This are the latest based on the picture. refno revno ax1 3 LT ax2 0 LT ax3 0 LT ax4 1 LT actually i have an formula in excel and i want to apply in ms access. here is the formula: COUNTIFS(A1:A10,A1)-1 it will count refno and then -1
  8. 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...
  9. N

    Custom ID Format

    yes thats what im trying to do and im limiting it up to 999. no that part is not fixed. CV-ST will change to diffirent category. if that part is fixed and doesn't change how can i code it.. thanks for the reply.
  10. 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!
  11. N

    Exclude Records for printing

    it should be multiple... thanks
  12. N

    Exclude Records for printing

    here's it is i already convert it to 2003.. thank you
  13. N

    Exclude Records for printing

    here's the screenshot of what im trying to do.. the selected record should not appear in the report.. i don't know how to code it.. im still a newbie. thank you hope you can help me.
  14. N

    Exclude Records for printing

    sorry again.. even 2007.. anyway i will try to look for 2003 access and i will install it.. thank you.. or i will attach the screenshot.
  15. N

    Exclude Records for printing

    sorry for that.. i attach the 2007 version.. thank you
Top Bottom