Search results

Sorry i meant when i open the report in layout view, Basically i have a report with fields concerning the details of items on loan. The date the item was loaned is recorded and the "date overdue" field is calculated from this. As said "Overdue" is calculated by comparng the current date to...

Thanks for the help, but now each time i try to open the form in layout view its starts asking me to enter a parameter query for "Overdue". Why is it doing this?

I've been trying to set up a calculated field as part of a query but have been having problems, usually my syntax is wrong but i have no real idea how to get around that. Basically i have a field in my query called "Date Overdue" - the date in which an item becomes overdue, the field i'm...

Thats great! Thanks alot for the quick reply, it's working fine now. :D

Hi, i've been having some trouble with runtime error 2465- "Microsoft access cant find the field "I" referred to in your expression" I'm trying to select a record from a list box and then open a form with that records details filled out in the fields of the form. Both ISBN and Copy No are key...