Search results

Hi Everyone, I am trying to calculate the number of weeks open by using a parameter query. I would also like to include in the query the option to use the finalised date to calculate the number of weeks the ticket took to complete. To calculate the number of weeks open I have used this...

Hi Everyone, I have a text box on my form that needs to show the number of days an item is overdue using the Due Date, minus the open date. I need to exclude negative days and only show genuinely overdue items. I have this: =IIf(IsNull([Due Date of Current Action]),DateDiff("ww",[Opened...

Hi, Really struggling to create the database that I need to. Its very hard when the courses I have done both focused on how to maintain a delicatessens inventory, when I am trying to learn how to design a database that we call our Question and Answer Database! Seems more like a project...

Hi Everyone, I am new to Access altogether and use the 2010 version. I have a form that has a memo field that shows a scroll bar when you click into it but does not show it until then. This means that anybody reviewing the completed form does not know that there is more information contained...

I have only just started working with Access 2010 and hope that by joining that I can get some help with how to do more than a couple of basic courses have taught me. Thanks, Kim