Hi,
I have a strange problem in displaying of reports on Windows XP and Vista. My crosstab query display mission records for a particular month, for employees of my organisation. For example if I search by month of "April", the crosstab query will display all staff ( of different departments) who were on mission in April. On Windows Vista the report displays fine, that is the query only fetches records for APRIL. However on an XP system, apart from APRIL records, the report is repeating staff member names along with dates of arrival and exit of previous months. I have really failed to understand what is causing this problem Please see the attached pictures 'XP.jpg' and 'Vista.jpg' for better understanding.
Here's my crosstab query:
TRANSFORM Count(tblMaster _TEMP.keyMaster ID) AS AvgOfkeyMasterI D
SELECT tblMaster_TEMP.[Mission Status] AS Msn, (tblMaster_TEMP .OrgName) AS Agency, tblMaster_TEMP. FullName AS [Staff Member Name], tblMaster_TEMP. Location, tblMaster_TEMP.[Mission Start] AS [Arrival Date], tblMaster_TEMP.[Date of Exit] AS [Exit Date]
FROM tblMaster_TEMP
WHERE (((tblMaster_TE MP.[Date of Arrival]) Between #4/1/2010# And #4/30/2010# AND tblMaster_TEMP. Location = 'ISB' AND tblMaster_TEMP.[Mission Status] IN ('E' , 'P', 'S') ))
GROUP BY tblMaster_TEMP. OrgName, tblMaster_TEMP.[Mission Status], tblMaster_TEMP. FullName, tblMaster_TEMP. Location, tblMaster_TEMP.[Mission Start], tblMaster_TEMP.[Date of Exit]
PIVOT Format([Date of Arrival],'Short Date') In (4/1/2010,4/2/2010,4/3/2010,4/4/2010,4/5/2010,4/6/2010,4/7/2010,
4/8/2010,4/9/2010,4/10/2010,4/11/2010,4/12/2010,4/13/2010,
4/14/2010,4/15/2010,4/16/2010,4/17/2010,4/18/2010,4/19/2010,
4/20/2010,4/21/2010,4/22/2010,4/23/2010,4/24/2010,4/25/2010,
4/26/2010,4/27/2010,4/28/2010,4/29/2010,4/30/2010);
I'll be grateful if someone can help me. Many thanks.
I have a strange problem in displaying of reports on Windows XP and Vista. My crosstab query display mission records for a particular month, for employees of my organisation. For example if I search by month of "April", the crosstab query will display all staff ( of different departments) who were on mission in April. On Windows Vista the report displays fine, that is the query only fetches records for APRIL. However on an XP system, apart from APRIL records, the report is repeating staff member names along with dates of arrival and exit of previous months. I have really failed to understand what is causing this problem Please see the attached pictures 'XP.jpg' and 'Vista.jpg' for better understanding.
Here's my crosstab query:
TRANSFORM Count(tblMaster _TEMP.keyMaster ID) AS AvgOfkeyMasterI D
SELECT tblMaster_TEMP.[Mission Status] AS Msn, (tblMaster_TEMP .OrgName) AS Agency, tblMaster_TEMP. FullName AS [Staff Member Name], tblMaster_TEMP. Location, tblMaster_TEMP.[Mission Start] AS [Arrival Date], tblMaster_TEMP.[Date of Exit] AS [Exit Date]
FROM tblMaster_TEMP
WHERE (((tblMaster_TE MP.[Date of Arrival]) Between #4/1/2010# And #4/30/2010# AND tblMaster_TEMP. Location = 'ISB' AND tblMaster_TEMP.[Mission Status] IN ('E' , 'P', 'S') ))
GROUP BY tblMaster_TEMP. OrgName, tblMaster_TEMP.[Mission Status], tblMaster_TEMP. FullName, tblMaster_TEMP. Location, tblMaster_TEMP.[Mission Start], tblMaster_TEMP.[Date of Exit]
PIVOT Format([Date of Arrival],'Short Date') In (4/1/2010,4/2/2010,4/3/2010,4/4/2010,4/5/2010,4/6/2010,4/7/2010,
4/8/2010,4/9/2010,4/10/2010,4/11/2010,4/12/2010,4/13/2010,
4/14/2010,4/15/2010,4/16/2010,4/17/2010,4/18/2010,4/19/2010,
4/20/2010,4/21/2010,4/22/2010,4/23/2010,4/24/2010,4/25/2010,
4/26/2010,4/27/2010,4/28/2010,4/29/2010,4/30/2010);
I'll be grateful if someone can help me. Many thanks.
Comment