query separation

  • Thread starter Thread starter sheetal
  • Start date Start date
S

sheetal

What I want to do: Create a query or report that displays last week's
data, and this week's data.

What I have done already: Firstly, I created a tabled that numbers all
dates with a week number. I have two queries. One called "this week"
and the other called "last week". Both are identical, except each
requests a week number, one says last week, and the other says this
week. Then I brought both together with a union query. The result is
last weeks data displayed, and underneath, this weeks data displayed.
So now I have it all in one table. (by the way is there any easier way
i could have done this?)

QUESTION, I want to display this information side by side, so a,
visually its presentable, and b, for comparisons to be made more
easily.

I dont mind if its easier in Report format or query format - but I
don't have a clue on how to do this.

Please help thanks

Sheetal
 
How about using subreports - one for each week, and dispensing with
the union query?

Peter
 
Back
Top