Search results

Well I will have a report with the loan given, taken, unreturned books, etc. I already have the query (parameter) prepared.:cool: So what I want is for the report to show the fine of each late book and no fine for books not late. I tried using the same function but it doesn't seem to work.:confused:

Any way to calculate the fine on a report.

1.Did I mention that I was using a query to bring up records. :D 2. The sugestion above does not work. when i pasted it into a form field it says '#Name?'. (i corrected =iif... to =if...):banghead:

Well first of all should mention that i am an beginner with access and more importantly i cannot do any type of programming. I am currently working o a Library Management System. most of the work is done but there remains two major problems. I want to calculate the fines that a member will...

Well, how do i that on a form level. any help at all is appreciated as i am a complete novice.

In a table I have 3columns with the primary key of MemberID. Of the columns in question, one is StudentID and the other is StaffID. What i want to do is that if a use enters the information in MemberID, he will not be able to input in the field in StaffID and vice versa. Can this be done? If...

I am currently working on building a database for a school library using an access database. in terms of expertise i probably am an novice. so i have built the database and all the tables. two table for books(one with ISBN as primary key[containing - ISBN (Text/String, 13...