Recent content by KatyB

This is great thank you so much - I just have one more question. If I enter date parameters (for example) as 1st Feb 2014 to 28 Feb 2014 I get the difference in days as 27, not 28. Please do you know how to resolve this? Many thanks

I have a contract management database where contracts have a start date and an end date. I also have a date parameter set up whereby I can show live contracts between overlapping records. I want to be able to count the number of days for each contract that is live between the dates of the...

Thanks for your reply Paul I understand the process of the link you sent through but I don't know about Driver tables or how the references to forms!xxx fits in. My underlying query is: SELECT Savings.StartDate, Savings.EndDate, Savings.MaterialCode, Savings.OldValue, Savings.NewValue...

I have a database for managing time related contracts. I need to be able to run parameter queries but if I query the data by start date then and contracts which are current but started before the first date entered in the query (this is the same for end dates) are not shown. Does anyone have a...