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...
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...
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...
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...
Hi,
I have two queries that I would like to show in one single report. I did so by using a subreport. I get the info I want to in the report, but I would like to change the presentation.
I would like to select some info of the subreport and show it under the line plan (empty cells...
Hi,
When launching a query, I always get the 'Enter Parameter Value' popup for 'SumOfTotal_Paid_USD' and 'SumOfNumber_Boxes'. I have tried several fixes, but unfortunately, none is working for me. Can someone please help?
Thanks,
Susy
Guys, I managed to translate the months into numbers. Thanks a lot for your help.
However, can anyone please explain why I shouldn't do simple calculations in my tables without using queries?
First of all, thanks to all for your help!
@theDBguy: Yes, I tried but it doesn't work.
@plog: I have stored a few calculations because they were very easy (simple multiplications). Is this so bad?
The people choose the months in a list. They don't have to type it.
@CJ_London: I want to do...
Hi,
I would like to translate a month (January, February, etc.) into numbers (1, 2, 3, etc.). I have seen that several people have asked the same question before, but I am unable to apply the solutions to my DB. Any recommendations?
Thanks,
Susy