Need Help

[Anonymous]

Hi ,

I have table A:

Date	Year	Invoice_No	Stock
20150101	2014	1	10
20150102	2014	2	20
20150103	2014	3	30
20140104	2014	4	40
20140105	2014	5	50
20140106	2014	6	60
20140107	2014	7	70
20140108	2014	8	80
20140109	2014	9	90
20140110	2014	10	100
20140111	2014	11	110
20140112	2014	12	120
20140113	2014	13	130
20140114	2014	14	140

And table B:

Invoice_No
1
2
3
4
5
6
7
8
9

Now I want when I select year or date I want sum of stock related to table B:450

and remaining 600 for table a Invoice number

Thanks

[Gysbert_Wassenaar]

See attached qvw.

[Anonymous]

Hi Gysbert,

I have attached file and I want 345 and 456 records only

pls help