Report generation

[Ezhilan Ilangovan]

Hi,
I am a neophyte in MS access. I have a clear view of basics of SQL. Please help to solve my problem.

I use the following table to maintain the testcase execution data:

EXECUTION DATA:

S.No
UC #
Headline
Date of Execution (MM/DD/YYYY)
Test Status
Test Status - 0628
Test Status - 0629
Test Status - 0630
Test Status - 0701
Test Status - 0702
Test Status - 0705
Test Status - 0706
Test Status - 0707
Test Status - 0708
Defect ID (New)
Defect ID(Existing)
Testdata Used
Additional Comments
Tester
Blocking Issue#
Test Case Type
Priority

The value of Test Status, Test Status - 0628, etc., can be one of the following - BlockedCannot be executedDeferredFailPassPending clarificationPending dataSetupTo be executed

I have to generate a summary report like the following:

Day# Date [No. Blocked] [No. Pass] [No. Fail] [No. Deferred]
1 28th june
2 29th june
3 30th
4 1st july
5 2nd
6 5th
7 6th
8 7th

Please let me know how to generate this summary report in Access. Thanks in advance.

 

[namliam]

I would guess, import your file the split the values based on the "-"
Then you have yourdate and your testvalue seperated.

From there it should be a pretty simple crosstab?