C
Crown Royal
I have built a database where I have several types of queries, which are
reporting daily, Mtd, and Ytd figures. It all works very well, however, I
have been trying to build reports that would give me the sum of the tables by
date, which I can't seem to figure out. This report has to access several
tables, and since I am also calculating Mtd and Ytd figures, I am finding it
difficult. The main problem is as I see it is that if the users put in data
for lets say today, but I want my report to give me a daily, Mtd, and Ytd
figure for 2 days ago, I get a total for either the year or the month
depending on how I build my query. A parameter query is not helping either,
it still gives me a sum of the whole month or year. I'm not sure if I
explained this properly, since I can see what I've done and you guys can't,
so I hope someone will understand my dilemma
Eric
reporting daily, Mtd, and Ytd figures. It all works very well, however, I
have been trying to build reports that would give me the sum of the tables by
date, which I can't seem to figure out. This report has to access several
tables, and since I am also calculating Mtd and Ytd figures, I am finding it
difficult. The main problem is as I see it is that if the users put in data
for lets say today, but I want my report to give me a daily, Mtd, and Ytd
figure for 2 days ago, I get a total for either the year or the month
depending on how I build my query. A parameter query is not helping either,
it still gives me a sum of the whole month or year. I'm not sure if I
explained this properly, since I can see what I've done and you guys can't,
so I hope someone will understand my dilemma
Eric