Recent content by linux44

it ask you for starting and end date but it wont bring up any details

it is not working

hi i have created a database for attendance register and need to create report for it before produce report it should ask you the date like say from when to when example of it you would put from 10/10/2008 till 20/10/2008 my problem is in query ,in criteria i can put "[enter date]"but iw...

thanks a lot it works thank you very much u saved me :D

many thanks for response but it wont work does yes mean ticked?

hi i have table for attendance monitor and contaion following attribute: session ID Student Id Attended session which is in yes/no format or in other work it give u option to tick it date and now what i want to do is that create a query and tell it to only count the number of attended...

hi i have table called student and want to create query to show what is the detail of specific student by that i mean i dont want query to show all the student details,what i want is ,query ask me question of type the student id that i want to see the details about i know i shoudl do that...

i found it difficualt and it is about 2 day i am working on it i want to use attandance register for dance class where there is 10 lesson in each class what i need is that when i type the session id bting up a list with the name of student registerd in this class and in the other side of it...

hi i just want to know how could i create a Attendance Register in Access 2003

ok the thing i am saying is differ i have student id as auto number and also session id as autonumber the problem is when i create table called student session to solve many to many i need student id(fk)ad session id(fk),when i am doing that it give me error it says that in one table i could...

thanks for responding that is the part that i dont understand (defined as Long to hold a copy of Autonumber PK from Session table)

i dont understand what do u mean by defining it as long does it mean the type should be number and format of it long ?

StudentSessionID(PK) StudentID(FK) defined as Long to hold a copy of Autonumber PK from Student table SessionID(FK) defined as Long to hold a copy of Autonumber PK from Session table could u please explain a bit more please thanks

Ive got problem with defining foreign key i explain what table ive and what i want between my Student ,Session there is many to many relation that student session connect them together student: Format student session: Format Student ID Autonumber...

hi i am new to access 2003 ,i would like to know how do i tell access which attribute is foreign key of another primery key ,for example if i have two table 1.student 2.order i want to have student id as foriegn key in order how would i do that ? thanks