Crosstab Query

[Mr_Stanley]

Hello,

I wonder if anyone can help me, I have crosstab queries set up to show
orders recevied and orders closed for two teams by each week of the current
year, ( fields are Date_Received and Date_Closed )both of which are date and
time formatted, that all works fine.
What I'm also trying to achieve is a count of Orders not closed at midnight
on the last day of the week ( weekending Sunday ) .

Thanks Robert

 

[Jeff Boyce]

Are you saying that you wish to see the Orders received in a week but not
closed in that week?

One approach might be to first find all Orders received by week, then find
all Orders closed by week, then all the Orders from the first list not in
the second. Then you could run your crosstab on the "not-in" list (the
third query in the previous sentence).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/