 Help needed with Uni Assignment PLEASE!!!! [message #264860] |
Tue, 04 September 2007 17:43  |
alanjohnson500
Messages: 4
Registered: September 2007
|
Junior Member |
|
|
Hi, I have an assignment I'm currently working on but I'm a little bit stuck and was wondering if I could get a solution...
Background:
I'm setting up a library database. There are 3 tasks that need to be completed.
Task A: Creation of the database tables - all done!
Task B: Updating / Inserting / Deleting records - all done!
Task C: Creating a Report:
"A summary of the number of times each title has been borrowed by each category of user in the last year"
Basically I just need to do the report, I'm on the right track (so I've been told with what I've currently done, just can't figure it out 100%)
My code for all three tasks are included as an attachment:
What's happening is the report is showing the same number of books being borrowed for all 3 member categories (SS = School Student, SFS = Sixth Form Student, SM = Staff Member)
These are not the same, but are different....
How can I fix this?
Many Thanks
-
Attachment: forum.txt
(Size: 4.21KB, Downloaded 473 times)
[Updated on: Tue, 04 September 2007 17:44] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Help needed with Uni Assignment PLEASE!!!! [message #264865 is a reply to message #264864] |
Tue, 04 September 2007 18:01  |
alanjohnson500
Messages: 4
Registered: September 2007
|
Junior Member |
|
|
This is half the problem, I go to university in the UK but they've really taught us nothing, the main lecturer was off most of the time so we've been pretty much left to it
Although we've been told its really simple, I think I'm there just need direction on what to do next
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
