Search results

  1. R

    Adding up 3 columns

    Dear All, I have another question, even more stupid than the previous. This is a basic query, but my brain does not work :banghead: I have an append query. I want to get a column that is the sum of 3 other columns: Oil_T_C_(bpd) Gas_T_C_(MMcfd) LNG_T_C_(Tonnes_per_Annum) 1000...
  2. R

    Adding a new append query to a macro

    Dear all, I was wondering if you can help me. There is a macro that contains 1 Make Table query and 6 Append queries. The result of the macro should normally be obtained from the Welcome Window. I need to add another Append query. I have created the query itself,I have added it to the Macro ...
  3. R

    Do I need to use access or Excel is enough?

    Hi everyone Can somebody please help me? I am supposed to somehow obtain a table with data that must be "pulled" from 2 excel spreadsheets. I will try to show what the 2 spreadsheets contain(i will mention only the columns i am interested in): Spreadsheet 1 User Status y pass...
  4. R

    Newbie

    Hi,everyone And nice to meet you all. The reason I am joining this site is because my interest in databases and SQL. I have no experience with access, but I dealt with Postgress and MySQL during my studies and I am trying to teach myself Microsoft SQL Server at the moment. But at work Access...
Back
Top Bottom