Recent content by MattyJacks

spikepl - Yeah, make a query using fields from a form. DClarke - That makes absolutely no sense to me. I don't know that much about databases could you put this into simple english please.

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

This doesn't really help me as i am quite new to Access. Also i need this to be added to an unbound box on a form, not in a query.

Or you could just selec the Application option when you save the form. Save As-> File Type -> MDB Application

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.

This is a job i have to set up for the librarian at my school however i have next to no expericnce with sql or access functions.

Oh... i feel like a right idiot now. :) How did i not see that in the first place. Thanks for pointing that out. Any ideas with the due date method to fit with the term dates. This is because the due date works if there were no holidays, but there are so it doesn't. My idea is: =DATE() -...

Thats great, thanks!! Thats sorted the Fines part but i am still stuck with the form giving me minus dates for the DueDate and i cannot delete any fields, due to the fact that i have been instructed by my boss to have those specific fields. Due date = 14 days after loanDate, excluding weekends...

I am a bit of a beginner with Access i must admit. I typed in the formula above and changed the field names appropriately and it just said NAME?# could you have a look at that also while you have the database. I have attached it onto the other thread.

ok, the file is attached, the form is called STUDENT1. Thanks!

in the related tables those fields are all defined as Date/Time. if you don't believe me i could send the database to you. The form in the database is called STUDENT1

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...

Thanks!! This calculates a due date but sometimes it calculates it -6 days and some other times it calculates it +14 days. Why is it doing this?? I am a bit confused..

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...