Recent content by frenzied_female

Thank you both so much for your fast replies! Fixed my issue perfectly, i only had to swap the order of the opened date and finalised date that i had around the wrong way so that i didn't get a negative number result. You guys are the best! :D

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

Thank you so much, Arnel! The 0;"";0 did the trick :)

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

Thank you very much for your help. I really do appreciate it and i'm sorry that I haven't explained myself very well.

I want to move information from excel to access so that we can track each entry and update them. Each one can have a few things that are being done to it by different people before it is finished. Sometimes there is a lot of work done on a entry that needs to be added with a date and name. I...

I have attached the form that is to be used for the data entry and to look at the records that have already been recorded. I need to have each of the tab pages at the bottom of the form be able to have entries added to them in a chronological order with details of the various updates, I have...

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