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?
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 :(
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:
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?
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...