Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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?
  6. A

    Matrix Table Query

    I am working with a matrix table like the one below: And I want to basically gather all the combinations of the vertical and horizontal values, where the middle value is equal to 2. Or basically whenever there is a middle value of two, which are the correspoding vertical values and...
Back
Top Bottom