Recent content by sandy70

  1. S

    Solved Lowest and Highest price and date

    for the lowest price Date , i am sorry I tipe the wrong date You right its 28 May 22 for the highest Price Date , my boss want to know when the highest price start to begin
  2. S

    Solved Lowest and Highest price and date

    tq so much its work :D :D
  3. S

    Solved Lowest and Highest price and date

    Tq for correction The price is correct but the date is not The result i am looking for Item 01 Lowest > 22 May 22 Highest > 04 Aug 22 Item 02 Lowest > 27 Jan 22 Highest > 04 Aug 22
  4. S

    Solved Lowest and Highest price and date

    how about the Date ?? the Date i am looking for is 04 Aug 22
  5. S

    Solved Lowest and Highest price and date

    Sample attached
  6. S

    Solved Lowest and Highest price and date

    hi all is there anyway to find the highest and the lowest price related to date ?? The result i am looking for : Item 01 Lowest > 170.000 > 22 May 22 Highest > 189.000 > 04 Aug 22 Item 02 Lowest > 171.000 > 27 Jan 22 Highest > 192.500 > 04 Aug 22 for the price i can get from query using...
  7. S

    DLookUp with multiple criteria

    tq so much , its done
  8. S

    DLookUp with multiple criteria

    so there was prices for some period of date ( Start Date and End Date ) so what i like to do is when Date= 03 Feb 20 and Des= Pro 02 , the query looking for the price for Pro 02 that the date in the range 17 Jan 20 to 26 Feb 20 So 03 Feb 02 is in between 17 jan 20 and 26 feb 20 , the price of...
  9. S

    DLookUp with multiple criteria

    i try that and the result : the 17 jan 20 Pro 03 is empty and i try to add 03 Feb 20 and empty too
  10. S

    DLookUp with multiple criteria

    non-equi join ??? Can u explain more ???
  11. S

    DLookUp with multiple criteria

    so i try using this DLookUp("Price","[PriceList]","Des=[Des] AND StDate=#" & [Date01] & "#") and the result like this something wrong ???
  12. S

    DLookUp with multiple criteria

    I have queries like this is it possible to lookup the price base on the date and product ???
  13. S

    Subform Problem

    TQ June7 My bad with the event Just delete all Enter event and move the event from enter to After update Now everything works fine And sorry for my miss spelling :D:D:D
  14. S

    Subform Problem

    Can somebody help me with my subform plz I dont know what wrong with the form My subform only can have 2 record only Need to reopen the form to add another record Plz take a look at my form
  15. S

    Problem with Transform Data

    its work tq :D:D:D:D
Top Bottom