Search results

Is it possible to create a query from a form? If so, how??

Is there anyway to count the number of records down a specific field in a form which contain a null value. If anyone knows any functions which may help it would be very appreciated.

In a library book database i need a formula to calculate fines for every day overdue the book is of the return date. E.g. - returnDate = 15/03/2011 and dateReturned = 20/03/2011. Difference = 5 days. So fine = 5 x £0.20 = £1.00. I need a formula to be inserted into an unbound field in a...

I have a problem. Where in a library style database the book is loaned out on a certain date (loanDate), e.g. 15/3/11. I then need the query to automatically calculate the due date of the book in the form in the next field (returnDate). E.g. book loaned out on 15/3/11 + 14 days = dueDate on...