Search results for query: *

I am trying to create a crosstab query that will sum hours between dates, based on system failures. In the table below, the first three columns are from the table, the last two columns, is the data as I would like it to appear. I am posting here, because I believe I will need some VBA for this...

Thanks for your help jedraw!, After walking away and thinking about your reply, I realized you were right. I now have a query giving me the results that I need. Thanks again, and have a star!

Thanks for your recommendation, and I agree that doing this is not the normal practice. But because of the complexity of this project, I must do it this way. By the way this is a temp table that will be deleted and replaced every time the code is executed/report is needed.

I have an access table that has two date fields. These fields are titled StartDate and EndDate. They represent a range of time. I am simply wanting to put these ranges into a new single column table using VBA. The range needs to include the StartDate, EndDate and include every date that is in...

I have tried the AfterUpdate of the list box to change the recordsource of the graph as well as the code above, which is also triggered by the afterupdate of the listbox. In both cases If I select a value that has a series collection of 1, then select a value that has a series collection...

I am struggling with a access database I am working on. I have a form with a graph and a list box. After update of the listbox I would like to update the graph's recordsource. The recordsource will not be based off of the same table or query. I have this somewhat working, however when I...

3 text boxes. Name them txt1, txt2, txt3 The control source of txt3 = [txt1] - [txt2] Hope this helps

This is still a great option. Just instruct the managers/leaders that are performing the evaluations, to save the .dot file to their hard drive. Then, when they are ready complete the evaluation they need to open the file by double clicking on the icon in explorer. Or if the file is saved on...

Gerry, Gave you great advise, put a table on you form get it all set up the way you want it then make the color of all of the borders of the table that you do not want to see white.

It is possible to make a template in word. First create the document that you want, but be sure to use the form toolbar, insert controls that the end user will complete, such as a text boxes where the end user will put the fax number, the receipent etc. Name: TextBox Phone: TextBox Fax...

Binder is still available in Office 2003. It, however, is not installed by default. If you insert the setup disc, and selct custom install you can selct and install Binder.

Try this, Open the form in Design mode, change the property "Data Entry" to Yes, save and close. Now when you open the form it will always be a new record.

Woo-Hoo it works. Thank you So much for your help. It does give me more then one record for each employee but I can easily create a "min" on the date column. Thanks again for your help. Rob

2003, happy to convert If i need to. If so tell me which version you have.

here I get "Enter Parameter Value dialog box asking for the "Duration"? sorry to be such a pain but I am really struggling here.

PH, If I paste the sql statement you suggested I get a "Enter Parameter Value dialog box asking for the "5th Anniversary" Can you tell me what I am doing wrong? I really appreciate your help.

PH, tblEmployee does not have any dates. all dates are in the tblEmployment

Let me state this question another way. I want to know the 1825th day of these ranges if they were all related to 1 person, starting with the earliest range. StartDate EndDate 8/15/77 2/19/78 3/31/80 9/19/82 4/24/83 6/25/89 The result in this case would be 4/28/85 StartDate...

Only 2 problems with that. 1st he did not work for us on 6/24/1986 and secondly 5 years employment with us would have been 8/15/82

You are probably right there since it has happened in the past, however in addition to the 5 year anniversary I am modifying the query to show the 1,3,5,10,15 & 20 year anniversaries. This is going to then be used to distribute to the employees for their evaluation as we transistion from...