Recent content by Marijn

  1. M

    Compare price fields in same column and select the lowest price.

    I fixed the problem using 2 queries btw. qry1: Select Id, Min(Price) As Minprice From tbl_products Group by Id; qry2: Select qry1.id, qry1.Minprice, tbl_products.Winkel From qry1 as qry1 Inner Join tbl_products As tbl_products On qry1.id = tbl_products.id and qry1.MinPrijs =...
  2. M

    Compare price fields in same column and select the lowest price.

    Lol Now I need to fix my price tables. XD
  3. M

    Compare price fields in same column and select the lowest price.

    Okay, I am totally stuck here, and I hope that you can help me. I am working with Access 2010. My table looks like this: id || Product || Price || Store || Storeno. || 1 || Hammer || 5,99 || Gamma || 1001 || 1 || Hammer || 6,99 || Karwei || 1002 || 2 || Nails || 3,99 || Gamma || 1001 || 2 ||...
  4. M

    Greetings from Groningen, the Netherlands

    Hello, My name is Marijn and I'm from the Netherlands. I am working with access for quite some years now, but I am still learning. I hope to solve some issues here I am currently dealing with. Thanks in advance.
Back
Top Bottom