Search results

  1. R

    Using Min as Formula in Query to Find Min values from range of fields

    Thank you so much Galaxiom for taking your time to help on this. I'm greatly appreciate it. I will need some time to read thru and try on your advice. I'm currently clearing my work for my xmas holiday next week. Shall give revert back once i'm back from my break. hopefully, i'm able to work it...
  2. R

    Using Min as Formula in Query to Find Min values from range of fields

    thank you for this.. you wouldn't know how happy i am on your help. i have sleepless night for months trying to learn by myself.. my greatest thank you to you.......
  3. R

    Using Min as Formula in Query to Find Min values from range of fields

    Hi Galaxiom, thanks for your advice. could you advice what's the best way for me to organize the structure. i'm just learning access from youtube, i thought it will help to lessen my daily task of checking multiple rates and also trying to impress my bosses.. but now i'm end up with some huge...
  4. R

    Using Min as Formula in Query to Find Min values from range of fields

    thanks for help.. here is my screenshot on the query that i created. Can you guide on how to use your code in my case. :):) https://i.imgur.com/hC3ZbOd.png one of my shipping rates tables : https://i.imgur.com/oDIEjO2.png shipping zoning by shipping account: https://i.imgur.com/K23Mkh1.png...
  5. R

    Using Min as Formula in Query to Find Min values from range of fields

    Thanks for the link but how do i insert the code to my current query? Below is my SQL code from access. I'm building the code using access expression builder.. guess there is where my limitation is. I have no idea how to write a proper sql code. #SELECT [IATA Code].IATACode, Weight.Weight...
  6. R

    Using Min as Formula in Query to Find Min values from range of fields

    i have rates tables and zoning for each shipping account but couldn't figure out to to Min query for each line.
  7. R

    Using Min as Formula in Query to Find Min values from range of fields

    Hi, i need some help here. I'm creating a query that could help me to check the lowest values from range of fields. I needed this query to compare cost of shipping to selected countries and weight from different shipping account no that i have. The query should check the lowest rates and return...
Top Bottom