Question: I am trying to create a select query in access with two tables I want to link/create a relationship.

Normally, if both tables contains same value you can just "drag" and create a link between those two columns.

In this case however, the second table have an " /CUSTOMER" added at the end in the fields.

Example;
Table1.OrderNumber contains order numbers which always contains 10 characters

Table2.Refference contains same order numbers, but will have a " /CUSTOMER" added to the end.

Can I link/create a relationship between these two in a Query? And how?

Thanks for the help!
Sebastian

Answer: 
From the C Standard (6.7.9 Initialization)

> 
> 4 All the expressions in an initializer for an object that has static
> or thread storage duration shall be constant expressions or string
> literals.
> 
> 
> 

The string literal defined in this record

```
int p = fun( (int[3]){a,b,c} , 3);

```

has automatic storage duration. So you may initialize it with non-constant expressions in particularly using the variables a, b, and c.

Pay attention to that as the function does not change the passed array then the first parameter should have the qualifier `const` and to avoid overflow it is better to declare the return type as `long long int`.

Here is a demonstration program.

```
#include <stdio.h>

long long int fun( const int * a, size_t n )
{
    long long int sum = 0;

    for ( size_t i = 0; i < n; ++i )
    {
        sum += a[i];
    }

    return sum;
}

int main( void )
{
    int a = 3, b = 2, c = 1 ;

    printf( "%lld\n", fun( ( int[] ){a, b, c} , 3 ) );
}

```
Well, yes. The array is being initialized as it should which can be tested by printing it.

The array is also being sent to the function properly as p returns 6. However, do note that you are making a new array to send to the function.