Discussion :

[ostrich95]

Bonjour à tous,

Je rencontre un problème de syntaxe lors de la création d'une requête.

Je dispose d'un formulaire où je peux entrer un IDclient, sa date de gain et ses 8 premiers volumes (chacun dans une zone de texte).

Je veux ensuite écrire ces 8 volumes dans une table TonnagesEstimés.

J'utilise pour ce faire une requête INSERT INTO avec UNION ALL.

Voici le sql de la requête:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
INSERT INTO TonnagesEstimés
SELECT *
FROM [select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week1] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]) as numSemaine, year([FORMS]![GainFutur]![dateDebut]) as numAnnee, [FORMS]![GainFutur]![dateDebut] as tdate from tableunion
union all
 
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week2] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]+7) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+7) as numAnnee, [FORMS]![GainFutur]![dateDebut]+7 as tdate from tableunion
union all
 
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week3] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]+14) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+14) as numAnnee, [FORMS]![GainFutur]![dateDebut]+14 as tdate from tableunion
union all
 
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week4] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]+21) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+21) as numAnnee, [FORMS]![GainFutur]![dateDebut]+21 as tdate from tableunion
union all
 
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week5] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]+28) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+28) as numAnnee, [FORMS]![GainFutur]![dateDebut] + 28 as tdate from tableunion
union all
 
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week6] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]+35) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+35) as numAnnee, [FORMS]![GainFutur]![dateDebut] +35 as tdate from tableunion
union all
 
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week7] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]+42) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+42) as numAnnee, [FORMS]![GainFutur]![dateDebut] +42 as tdate from tableunion
union all
 
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week8] as TonnagesEstimés, datepart("ww",[FORMS]![GainFutur]![dateDebut]+49) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+49) as numAnnee, [FORMS]![GainFutur]![dateDebut] +49 as tdate from tableunion];

Voici l'erreur que j'obtiens:
"mise entre crochets non valide du nom 'select [FORMS'. "

Quelqu'un aurait il une idée de la syntaxe exacte de ce type de requête?

En vous remerciant d'avance,

Ostrich95

[ostrich95]

Je devais juste changer des [] en ().

Voilà le code SQL final:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
INSERT INTO TonnagesEstimés
SELECT *
FROM (select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week1] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]) as numSemaine, year([FORMS]![GainFutur]![dateDebut]) as numAnnee, [FORMS]![GainFutur]![dateDebut] as tdate from tableunion
union all
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week2] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]+7) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+7) as numAnnee, [FORMS]![GainFutur]![dateDebut]+7 as tdate from tableunion
union all
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week3] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]+14) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+14) as numAnnee, [FORMS]![GainFutur]![dateDebut]+14 as tdate from tableunion
union all
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week4] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]+21) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+21) as numAnnee, [FORMS]![GainFutur]![dateDebut]+21 as tdate from tableunion
union all
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week5] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]+28) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+28) as numAnnee, [FORMS]![GainFutur]![dateDebut] + 28 as tdate from tableunion
union all
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week6] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]+35) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+35) as numAnnee, [FORMS]![GainFutur]![dateDebut] +35 as tdate from tableunion
union all
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week7] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]+42) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+42) as numAnnee, [FORMS]![GainFutur]![dateDebut] +42 as tdate from tableunion
union all
select [FORMS]![GainFutur]![CodePTL] as CodePTL, [FORMS]![GainFutur]![week8] as TonnageES, datepart("ww",[FORMS]![GainFutur]![dateDebut]+49) as numSemaine, year([FORMS]![GainFutur]![dateDebut]+49) as numAnnee, [FORMS]![GainFutur]![dateDebut] +49 as tdate from tableunion);

A bientôt,

Ostrich95