Search results

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 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 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...

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

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

Hi, I am creating an app in Acces and I would like to add a SUMIFS equation into a table that would use another table or several other tables with 1-2 dimensions. To illustrate what I am trying to do: I have a cost in a foreign currency and I would like to automatically translate it to USD. My...