Hello, I’m trying to bring the fuel price from the “Preturi combustibil” to the “Registru Productie” according to the last entered date and the car’s registration number. My problem is that the car is not refueled at the gas station every day and when the date is between the 2 refueling (for examp…

I think a query with with conditions to match, License Plate is This Row → License Plate l, and Date is on or before This Row → Date, should work. Set the query sorting to sort ascending by date and only return 1 row. Then use a Single Value column to retrieve the fuel price from the query.

[image] Stefania_Oancea: I’m trying to bring the fuel price from the “Preturi combustibil” to the “Registru Productie” according to the last entered date and the car’s registration number Does it mean you need to pull the info from the last line the signed-in user has entered to the “Preturi …

Isn’t this basically the same problem that we already solved below? [image] Filter data components Ask for Help Hello, Can someone help me? I want to display the last registration number(Licence plate no.) entered by the driver, but not based on date because Saturday and…

Well, not really. This time I want that the price to remain unchanged because I want to calculate the total value of the fuel for each day and each car. I also used your advice and I thank you for that, but for example I want that the price to be for every day, only on the days when a fuel receipt …

So ultimately, what is the link between your “Preturi combustibil” table and the “Registru Productie” table? Is it a combination of date and license plate? I’m just trying to understand your data’s logic here and what you’re trying to get.

Yes, it is a combination of date and license plate. I try to bring into the “Registru productie” the price of fuel based on date and license plate, but with conditions I mentioned above.

Yes, it worked. Thank you very much!!! :clap: :clap: :clap:

Query problem

Ask for Help

Darren_Murphy January 28, 2024, 8:34am 3

Isn’t this basically the same problem that we already solved below?

Topic		Replies	Views
Formula to show the latest fuel price? Ask for Help	11	287	December 10, 2022
Filter data components Ask for Help	12	242	January 23, 2024
Function yesterday Ask for Help	6	159	January 17, 2024
Lookup item in another table based on date selection in target table Ask for Help	1	220	December 27, 2022
Get last price for collection from all the listings Ask for Help	2	254	November 28, 2023

Query problem

Related topics