Hi, Im trying to calculate due date for an update query with different loan periods so for eg: Loan date is April 10 for an OPSH (Open shelf book) with a loan period of 7 days, an RBC1 (reserved book overnight) has a loan period of 1 day. How do i get the due date for each book using a parameter query?
Creating an update query that uses multiple parameters
- Thread starter kishkaye
- Start date
Abraham Andres Luna
Child of God
- Joined
- Mar 14, 2018
- Messages
- 699
- Reaction score
- 227
I guess you are using Access? Or maybe SQL Server? Anyway you can add and subtract from a date column to get the due date:
SELECT CAST(NEW DATETIME() + LoanPeriod) AS DueDate FROM Loans
Some helpful links:
support.office.com
SELECT CAST(NEW DATETIME() + LoanPeriod) AS DueDate FROM Loans
Some helpful links:
Access SQL: basic concepts, vocabulary, and syntax - Microsoft Support
Learn how to retrieve data from an Access database by using Structured Query Language, or SQL
PARAMETERS declaration (Microsoft Access SQL)
Office developer client VBA reference documentation
docs.microsoft.com