Recent content by Susy

Thanks Micron. What do you exactly mean? I have created the app on the C and I thought to copy it to the cloud and then split it in the cloud. Do you think that this is a bad idea?

Thanks a lot. Indeed in the Linked Table Manager, there was a weird link that I have never requested! I simply deleted it and everything works fine now. Thanks a lot!

Hi all, I have tried to deploy my database on OneDrive, I splitted it in the OneDrive and then I tried to share the front end part, but unfortunately it didn't work. The person with whom I shared it, has received the following message when opening it: For me, the app worked perfectly. After...

Thanks a lot Vlad for your help. I managed to update the table!

Hi Vlad, Thanks for your input. I used your SQL statement and there was a syntax error (missing operator) in query expression 'FX_Month:Month([Date_Transportation]). Any advice? Moreover, as this query uses two tabs, I am wondering if I shouldn't specify the tab I am referring to: SELECT...

Mhhm ok , I see what you mean. But couldn't I translate the Date_Transportation into a numerical month and only use this info for the FX_Value?

Mmh not sure to understand your input. I don't think that there is any ambiguity. Lets have a look at my data in the tab Upload_FX: Then in my tab Upload_Freight, I have the Date_Transportation that gives me the FX_Month, FX_Year in the tab Upload_FX, and for the Currency, I use the...

Thanks, yes, probably this is why I am not able to do it! ;) Actually, i wanted to update this field in order to run a query that translates the local currency into one single currency. In my tab Upload_FX I have the FX rates and in my tab Upload_Freight I have some amounts in local currency. By...

Hi everyone, I don't understand the SQL syntax with JOIN and would be very thankful if someone could help me! What I am trying to do: I have two tables, Upload_Freight and Upload_FX: What I would like to do is to update the field FX_Value in Upload_Freight. The criteria are that the...

Ah thanks a lot! This is a great idea!

Thanks a lot. It works perfectly! Do you have any idea how I could simply complete the data and not replace it? Thanks, Susy

Hi Vlad, Thanks a lot for your help. I have tried your code, but it doesn't work: Moreover, is there a way to simply complete the table and not clear the contents? Thanks, Susy

Hi guys, I am trying to update an existing table with an Excel spreadsheet import, but I am struggling with one part: My codes work perfectly (print screen attached), I can import the data into a new table (highlighted in yellow), but I don't manage to change this and just actualise an existing...

Thanks Pat. I have tried to make the join, but as I am using calculated values in my tables, it doesn't work for all relationships. Consequently, I have to review some parts of my database. Thanks for the tip! ;)

@vba_php: Thanks for your input. In Excel, I would simply use a VLOOKUP or something similar. My criteria would be Bananas, Yellow, March. Would you recommend working on my queries to simplify the task? Or do you think that I will be successful to do it directly in the report? (I am not a...