Select Funciont

**XThomasX** · 04-14-2014, 04:56 AM

hi, i have 2 table and i would create a query with 2 table but in 1 table tblTurni i have Nominativo,Anno,Mese,1,2,3.... and in tblSigle Sigle,Ore. tblTurni1 = tblSigleSigle tblTurni1 = tblSigleSigle tblTurni2 = tblSigleSigle tblTurni3 = tblSigleSigle...... and in the query i would insert a value Ore if tblTurni1 = tblSigleSigla

ID	Nominativo	Mese	Anno	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	26	27	28	29	30	31
1	MARIO ROSSI			c	A

Sigla	Ore
a	6
b	7
c	8
d	9

i do it => (SELECT [tblSigle]![Ore] FROM [tblSigle] WHERE [tblTurni]![1] = [tblSigle]![Sigla])
this is the result

Nominativo	1	Espr1	2	Ore
MARIO ROSSI	c	8	A	6
MARIO ROSSI	c	8	A	7
MARIO ROSSI	c	8	A	8
MARIO ROSSI	c	8	A	9

but i would to receiv this result

Nominativo	Mese	Anno	1	Espr1	2	Ore
MARIO ROSSI			c	8	A	6

who can help me????????

**XThomasX** · 04-14-2014, 05:09 AM

i resolved

Select Funciont

Thread Tools

Select Funciont

Similar Threads

stuck if filed x is 10 character select "A" if field x is 16 characters select "B"

I have two multi select list boxes where I need to be able to select all or some of t

Select distinct, then select the FIRST occurring ID

Select field you want to search, select value, then Search

Muli Select List Box off Another Multi Select List Box

Posting Permissions