Recent content by Arlmachado

  1. A

    Replace Query ; with a ,

    What does it mean, its attached to my regional settings?
  2. A

    Replace Query ; with a ,

    I have tried it like this: Update 1 Set 1.[Bindungen] = Replace(1.[Bindungen], ";", ",") but it says there is an error with the Set 1.[Bindungen] part.
  3. A

    Replace Query ; with a ,

    The problem is I don´t know how to do that unfortunately and the solution needs to be easily done. I have built forms and other stuff around databases like that, so the change as to be minimal. Which is why I just wanted to change ";" to a "," which was used in the last table I worked with.
  4. A

    Replace Query ; with a ,

    Hello everyone, I am trying to do a replace query on a column of my table, but it keeps giving me error. I believe it must be an error with the syntax. I have attached what my column looks like below, and the type of fields there are. I always have a string of numbers plus letters, separated...
  5. A

    Filling a Column in Case Statement in reference to another column

    I am fairly new to SQL language and I am trying to do some work for Uni in Access. I have three columns: Bindugen, with values shown below, and then blank Columns Code and 33/SDGL: Bindungen: 33,811, / 811,SDGL,33,/ 33,812,SDGL, / 812,SDGL,/ 811, (etc.) My main column is Bindungen and I want...
  6. A

    ILF() function

    I believe it is formed by BC_1, etc. I didn´t make the table originally. I just receive it and need to work with it.
  7. A

    ILF() function

    I want to create a general ILF function for a columm. As shown on the image attached, I have two empty columms "Codes" and "33/SDGL". I want to create a function (will have to be a big expression I know) that connects both columns to the "Bindungen" column. As an example of the expression I...
  8. A

    Append Query Value to one cell of a specific table

    Thanks, you are right, I am going to try to explain myself better, however after a bit of considerations I thought it would be better to asked this question in the Forms forum.
  9. A

    Creating a very specific Form

    I have a very complicated basic data tables from which my final goal is to have the sum of Hectares, but with specific criteria involved. From a more general table I have to create Queries or Tables, getting the Bindungen and BC_1 through BC_6 related to specific codes or combinations (example...
  10. A

    Append Query Value to one cell of a specific table

    I have done a couple of sums of some data with a Totals Query, but would like that, each one could be appended to a cell of a table of my choosing. Is that possible? Can I append the value (which I got from a Query) to a specific cell?
  11. A

    Matrix Table Query

    Great! Thanks, you have been an amazing help. Cheers:)
  12. A

    Matrix Table Query

    Thanks! this works perfectly. I do have one question, so I can learn to change it a bit. How do I name the colummns? for example the H1_Row? Again I am very thankful for the help
  13. A

    Matrix Table Query

    Thank you so much. :) Just a quick question how do I run this database that you have made for the data with the excel table? If I need to change the middle values (1,2,3), how do I connect the excel table with the query?
  14. A

    Matrix Table Query

    Thank you so much, it would be so amazing if I could get a table will all those possible combinations without having to do it manually.
  15. A

    Matrix Table Query

    It´s on Excel at the moment, but I will export it to Access since I will be working from there on.
See more
Back
Top Bottom