Creating an update query that uses multiple parameters

[kishkaye]

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?

 

[Abraham Andres Luna]

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:

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

support.office.com

PARAMETERS declaration (Microsoft Access SQL)

Office developer client VBA reference documentation

docs.microsoft.com

 

[kishkaye]

Yes I am! What i had to do was create an update parameter query for EACH loan period, but is there a way to do it in 1 query?