Expressions

[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

 

[Guest]

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

 

[Marko]

How would I go about this? What would the validation
expression be?

-----Original Message-----
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