Search results

It works just great! You are amazing!!!! Thank you very much! :rolleyes:

I will rename them better afterwards. Thanks for your advice. I see what you mean now. But the 2 tables ([Price of Gasolio at Sedes] and Erogazioni) do not have any field in common so that I cannot join them. What I have in the Erogazioni table is the Date and in [Price of Gasolio at Sedes] is...

Hi plog, Thank you very much for your prompt reply. Yes, I do have a DLookup in my query. I still do not understand what you mean. But my "domain" in the DLookUp is another query: [Price of Gasolio at Sedes], I need to retrieve the value of [EURO/LITRI] in that query with the criteria that if...

I have just recognized that the error pops up in Form because of the error in the Query (I have the Query as the Record Source of the Form). So there is no error at all if I run the same code in the Form, but got an error in Query. It's strange!:mad:

Hello everyone :D, I am a newbie to Access. I have used this forum for 2 months and find it very useful. Most of the time, I do just follow the instruction from the posts and it works. However, today, I am not that lucky. When I use the following code: =DLookUp("[Price of Gasolio at...