Creating an update query that uses multiple parameters


Joined
Apr 9, 2019
Messages
2
Reaction score
1
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?
 
Ad

Advertisements

Joined
Mar 14, 2018
Messages
676
Reaction score
221
Ad

Advertisements

Joined
Apr 9, 2019
Messages
2
Reaction score
1
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top