Search results

  1. A

    Queries to print in DOS format

    arnelgp good day to you. what i mean a DOS print standard output or the basic RAW printing. :)
  2. A

    Queries to print in DOS format

    good day everyone. is it possible we can print our queries in DOS format or on dotted printout from a matrix printer? i dont know the correct term "dotted printout" or "DOS format?
  3. A

    to get sum between 2 dates

    yes it is alphabetically arranged. sorry ridders. next time i will use the # button to post my code:o. So i should rather use mm/dd/yyyy or mm/yyyy?
  4. A

    to get sum between 2 dates

    i see no problem with the total value displayed per month for each item. for example if there are two values recorded in a month, the figure displayed or the result of the total value for that month is correct. months is not arranged also when i tried mm/dd/yyy :(
  5. A

    to get sum between 2 dates

    here's the SQL text format
  6. A

    to get sum between 2 dates

    i intend having a format yyyy-mmm because it is a monthly basis not on a daily basis. So i want it on every heading to appear only the month and the year. if i change it to mm/dd/yyyy which i already did...more columns were added than with fewer columns in yyyy-mmm. :confused:
  7. A

    to get sum between 2 dates

    i did but still months are not in order.
  8. A

    to get sum between 2 dates

    yup i know. I just tried ashleedawg's post..but it's not working anyway. Well Galaxiom you know what?.... everything's OK now...finally! both Average and Sum all Ok now! but there is one thing...:)..how can arrange (sort) the date?
  9. A

    to get sum between 2 dates

    i already got the sum between two dates but not the average. please check the image attached.
  10. A

    to get sum between 2 dates

    i finally got the sum between dates but im still working how to get the average between dates
  11. A

    to get sum between 2 dates

    i think i need to resolve first in getting the average and sum between dates or within range then if by chance everything's resolved...than i could perhaps arrange the months or date in descending or ascending order. but right now i must put a total and average columns to get the value between...
  12. A

    to get sum between 2 dates

    ok galaxiom...i'll try...
  13. A

    to get sum between 2 dates

    Please check images attached... need help....pls. :confused:
  14. A

    to get sum between 2 dates

    sorry ridders i wasnt able to attach the images from my first post. i got a new post with images attached now. pls check., thanks
  15. A

    to get sum between 2 dates

    i'm back and still i'm stuck! i am attaching 2 images. please help me out with this guys. thanks :confused:
  16. A

    to get sum between 2 dates

    thank you all guys...i'll get you back later once im done here. so good to have all your contributions posted here. :)
  17. A

    to get sum between 2 dates

    i mean my format should be yyyy-mmm.
  18. A

    to get sum between 2 dates

    Ranman256 it is a total value per month then the overall total value from months within range. so the my format is yyyy-mmm.
  19. A

    to get sum between 2 dates

    i think im getting closer to this one. i'll let you know whatever comes out.
  20. A

    to get sum between 2 dates

    How am I going to formulate to get the SUM between two dates in a query? I already created a start date and end date as parameters but the TOTAL within range is incorrect. Aside from getting the right formula for the sum, I am also trying to get the average? please check attachments: Need...
Back
Top Bottom