27. april 2009 - 10:54Der er
2 kommentarer og 1 løsning
Need Report To Display MonthDates
Hi, I am working on studentsDatabase... and i store students Checkin Details in Checkin table... which is basically a timestamp which shows students Checkin time in INSTITUTE..i.e the date and time when student comes...Now i have something like this in my Checkin table: SID: Checkin: StatusCode: 1 02-02-2009 Present 1 03-02-2009 Present 1 04-02-2009 Absent 1 05-02-2009 Present 1 06-02-2009 HomeWork 1 09-02-2009 Present 2 02-02-2009 Present 2 03-02-2009 Absent 2 04-02-2009 Present 2 05-02-2009 Homework 2 06-02-2009 Present 2 09-02-2009 Present and so on....
also i have StudentsDetails table which stores details... Now i need a report which display:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 and so on till month end P A H P P P P P P P P P P A
and on top of report i can display labels: where P: Present; A: Absent; H:Homework..and so on..
Ret beset ønsker du at vise data både vandret og lodret. Den eneste mulighed for dette er at lave en krydstabuleringsforespørgsel. Der ligger en guide der hjælper dig igennem.
Lav en forespørgsel der med funktionen DatePart udtrækker datoen. Derefter en krydstab. på denne forespørgsel.
Thanks for Reply... My StatusCode is from ComboBox.i.e I have one more table which contains CID, Statustext, StatusCode... which is nothing but, present, absent so on.in StatusText..and i have one more field which says statuscode:which is Ab, Pr, Hm which contains actual code... So First(Left([StatusCode],1)) AS Status displays Values instead of text...
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.