Recent content by pantanna

  1. P

    addinf numdata from 2 queries

    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...
  2. P

    connecting 4 queries in 1 form

    the db will be used in a gas station. i would like to calculate the numbers of the pump counter of each kind of gas which is selled. unleaded, super unleaded, diesel, super. ie date counter nr 1/1/11 1578 2/1/11 1580 3/1/11 1585 the difference of the two days ie 1580-1578 calculated with the...
  3. P

    connecting 4 queries in 1 form

    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...
  4. P

    which is the right way ?

    yes i guess this is true. i had i teacher he always said, "u have to think simple in ur live if u want to solve ur problems!!"(he was a physician ) anyway. i am so glad i was working for hours... i have to many thinks to ask i ll come back sure. good day:)
  5. P

    which is the right way ?

    :D:D:D:):) i did it i did it!!!!! i was such a fool. i just had to think simple.... thanks anyway so much all of u for the great help. ;)
  6. P

    which is the right way ?

    good day to all of you. i would like to ask my dear friend mamliam, i could do only the first part but could manage it to join it right. maybe i did not enter the exaxt epression in the price field. coule u pls help me, because i am still learning. thanks in adnvance a lot. greeting from the...
  7. P

    which is the right way ?

    untilll here i made it. but i could not fix the rest. how can i enter the numbers and then calculate the difference? thanks again
  8. P

    which is the right way ?

    i THANK YOU SOOO SOOO MUCH FOR THE GREAT HELP. :) i will work on it immadiately and in case i have any question, pls let me bother u again :o it seems really easier now that u explained it.
  9. P

    which is the right way ?

    THANKS SO MUCH.....:):)!!! i only made the table and copied and paste the code...and ...that''s it... i think i am going to cry..... but i have to admit i would NEVER EVER made this by myself because i am learning by myself access and this is too difficult for me...my db are...
  10. P

    which is the right way ?

    thanks so much for your promt reply. what do u mean by calculating the previous date in a seperate column? it seems a little complicated....
  11. P

    which is the right way ?

    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...
Back
Top Bottom