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

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

Hi All. I have a database that I need help with and am not sure how to get the answer I need. 2 tables with a 1 to many relationship TblEmployees pk IDEmployee BadgeNumber LName FName TBLEmployment (Qry based on this table shows duration) pk IDEmployment fk idEmployee...

I have a table that was Imported, the structure of the table leaves a bit to be desired. What I would like to do is create a "make table" query to get the desired results. Here is my trouble, my table has a part number and a "level" I neet to show the parent instead of the level i.e curent...

I have a table that was Imported, the structure of the table leaves a bit to be desired. What I would like to do is create a "make table" query to get the desired results. Here is my trouble, my table has a part number and a "level" I neet to show the parent instead of the level i.e curent...

Hi all and thanks for all of the wonderful help I have received in the past. I have a complex problem and will try to describe it as well as possible. I have exported a Engineering Bill of materials out of JDEdwards into Access. The BOM structure from JDE is in a hierarchy order, meaning it...

Hi all and thanks for your help in advance. I have a xlt file (excel template) that is stored on the company network. The user opens this file and assigns a shipping package number. This number is then used in the naming of the new file on the network as an xls file. What I would like to do...

Hi all and thanks for your help in advance. What I would like to do is create a button on an Excel worksheet that does the following. Starts an email & inserts a hyperlink in the body of the email. This hyperlink will take the receipent of the email back to the excel workbook. This code...

This should have a very simple solution, but I am struggling to find the answer. I have 3 tables tblEmployee idEmployee(PK) Fname Lname Address etc tblDate idDate(pk) DateWorked(no duplicates) tbldetails idEmployee(PK) idDate(PK) hours AbsenceCode Comments. I have a form frmAttendance...

I would like to show the difference between two dates in months, also in partial months. An example would 10/1/02 to 11/16/02 would be 1.5 months DateDiff("m",Date(),[Date of Release])is my current formula but using the dates above my result is "-1" I do not want to use...