Expressions

  • Thread starter Thread starter Marko
  • Start date Start date
M

Marko

HI there, I currently have a database which records book
Loans.

I am creating a Loan query which currently has the
fields:

Student Name
Book Number
Loan Date
Loan Due
Loan Returned
Days Late
Fine Amount

What expression or form of validation could I use so only
books not on loan can be borrowed.

and

What expression could I use to prevent a book from being
renewed more than twice by the same student.

Thanks
 
Regarding the first part. You can build your validation inside the table or the properties of that field in the table. Second part, maybe you can run a query with count employee more than once and reference to it everytime a user tries to borrow the same book
 
How would I go about this? What would the validation
expression be?
-----Original Message-----
Regarding the first part. You can build your validation
Click to expand...
inside the table or the properties of that field in the
table. Second part, maybe you can run a query with count
employee more than once and reference to it everytime a
user tries to borrow the same book
 
Back
Top