Novice
Windows 10 
Access 2016
Hi guys,
I am quite new to access and I need some help for a school assignment involving a Library Database.
What I need help on is to create a Query capable of displaying overdue loans. I have included screenshots of the Query and the SQL. Having no idea how to use SQL I have really bummed out on this one.
If you would like to view my Database File, just send me your email and I can email it as the upload doesn't seem to work.
Thanks in advance!
Who is John Galt?
Windows XP Access 2007
It will be easier to do in design view if you're not familiar with SQL. Hint, you can use the Date() function to return today's date.
Novice
Windows 10 Access 2016
Oh, I probably should point out the assignment requires the use of SQL. I should add that I want it to display the loans that are overdue after running the SQL Command. I was thinking of something where it selects the Data which has a Due Date before the current date (meaning it is overdue).
Who is John Galt?
Windows XP Access 2007
Design view is just an interface to create SQL.
Master of Nothing
Windows XP Access 2010 32bit
So the SQL in the first image returns all of the records, yes?
How do you limit the records returned?
You know how to limit the records - you wrote it!
How would you write this in SQL??? (see http://www.w3schools.com/sql/default.asp)I was thinking of something where it selects the Data which has a Due Date before the current date
Query for overdue maintenance
Setting an alert that a payment is overdue
Posting Permissions
Reply With Quote