Search results

Im having trouble with the query named overdue in my database, im trying to get the query to list car details with the loan return date as the output. I think its due to a mistake with my relationships but im not sure how to resolve it, if anyone has the answer I would be very gratefull for the...

Ive got it now :) my problem was that I had equations as the control source for the calculated fields. Cheers for looking at it though :) Richard

Im probably doing something wrong but i cant get the date_loaned return_date and total cost saved into the temp_loans form through the temp_loans form.

Im having trouble trying to save data to a table. How can I save the data from form temp_loans to table temp_loans when it is added? See attatched file. The user starts by running the customer form. Im sure theres a simple way to try to move the fields when they are complete. Many Thanks...

Thanks very much for the reply :) I had the relationships, should have mentioned it, I got an error I think is through my poor interpritation of your syntax, i set the buttin too Forms("Customers").Customer ID = Forms("Loan").Customer ID The Customers form is called Customers and Loans is...

Im trying to set up a query to copy the value of a record in a field to another database table. Both tables contain the field customer ID and are forms. I want to be able to create a button which runs a query to copy the customer ID value of the current record shown in the form to another form...