Problema ACCESS 2003, Union Query
Problema ACCESS 2003, Union Query
ionutctn |
28 Aug 2007, 10:28
Post
#1
|
||
Membru cu TDI Group: Members Posts: 1.373 Joined: 20 November 04 From: Bucuresti |
|
||
--------------------
Dacia
1310
1998 Skoda Superb Elegance
People who say it cannot be done, should not interrupt those who are doing it. |
|||
Smiley |
28 Aug 2007, 20:55
Post
#2
|
Membru autentic Group: Members Posts: 1.138 Joined: 12 August 04 From: Bucuresti |
"SumOfDummy LoB" nu trebuia cumva incadrat de apostroafe in loc de ghilimele?
|
-------------------- |
|
ionutctn |
29 Aug 2007, 10:44
Post
#3
|
Membru cu TDI Group: Members Posts: 1.373 Joined: 20 November 04 From: Bucuresti |
Am reusit cu union query am facut in SQL......mersi mult de ajutor oricum.
|
--------------------
Dacia
1310
1998 Skoda Superb Elegance
People who say it cannot be done, should not interrupt those who are doing it. |
|
diaconuliviu |
30 Aug 2007, 08:14
Post
#4
|
Membru autentic Group: Members Posts: 5.569 Joined: 17 August 04 From: Space, the final frontiere |
Union query nu e qry de reunire a valorilor din doua sau mai multe tabele nu acelasi numar/tip de cimpuri?
Ce voiai tu nu e crosstab? |
--------------------
Opel
Corsa
2001
- xx Universul si prostia sint infinite.
De a doua sint sigur. SSP,K! |
|
liviu2004 |
15 Jun 2011, 19:04
Post
#5
|
Membru autentic Group: Members Posts: 1.184 Joined: 21 November 05 |
Am un tabel in access 2003. Am 3 coloane dupa cum urmeaza:
Data calendaristica 1, Data calendaristica 2, Initiale angajat Se poate face un cod care: 1. o data pe saptamana sa verifice daca "Data calendaristica 1" = data curenta + 4 luni atunci sa trimita un email la angajat cu un text predefinit; 2. o data pe saptamana sa verifice "Data calendaristica 1" > data curenta SI campul "data calendaristica 2" nu e completat atunci sa trimita un email la angajat cu text predefinit? Am vazut cateva exemple pe internet in visual basic dar nu neaparat pe aceasta structura si din pacate n-am suficiente cunostiinte sa modific codul la ceea ce as dori. Multumesc de ajutor. This post has been edited by liviu2004: 15 Jun 2011, 19:04 |
--------------------
Opel
Tigra Twintop
2005
|
|
Lo-Fi Version Harta site Parteneri Jocuri online Curs Valutar HRH Haine din lana merinos | Time is now: 27th April 2024 - 11:31 |