Search results

i have 2 queries qry 1 ________ id nr date t1 t2 t2 t3 total a t1*t2 total b t3*t4 summary1 totala+totalb qry2 ________ date r1 r2 r3 r4 ra rb rtotal a r1*r2 rtotal b r3*r4 summary2 rtotala+rtotalb the relationship in the tables is one to many with using the id nr in the according...

I had i great help a few weeks ago for making a query now i need help for a form . i have a table table one date num 1/1/11 100 2/1/11 200 3/1/11 300 i find the difference between current date and last date (100) and calculate it with the according rate. (1,80). this should make...

if i have a table with dates and nr ie: 1-11-10 - 300 2-11-10 - 400 3-11-10 - 500 how is the smartest way to find out the difference of 2 numbers by entering the according 2 dates ie from: 2-11-10 (400) to : 3-11-10 (500), it sould come out 100. i need your help. any help would be...