Search results

Im creating a library management system and I created a form for adding new borrowing events, it includes book, member name, book status, default value for the checkout date that will automatically populate for current date, due date that automatically calculates with dateadd function and return...

Hi, I have a query that shows all the books that have been borrowed. I created a form to show all these events they include Date Out Date Returned whether the book is out or available. I need to be able to add new borrowing events to this form, but I need a way to restrict it based on whether...

I have a report based on member information and I want to change the text color of the members last name to red if they have not paid their dues. The paid dues field in the table is check box for either yes or no. I have been messing with this for about an hour and I think I am close I am just...

Hi, I am working in a database and I need to calculate a persons age on a specific date. I am having a little trouble coming up with the correct expression for this, can someone help please? I have the DOB each person and use the DateDiff function I can calculate age as of Date(). Thanks,