Search results

I have a report that is run from a form for timesheets. I would like to change it so at the end of the week I can run all the timesheets off at once instead of each individual person. I changed the query so the that when I run it everyone is included in the dates. However when I run a report It...

I have a query set up to prompt users when their license will expire (30 days out). Problem is that there are 2 types of licenses and some have different dates. I would like to have a report where I could see all the people that are about to expire either it be one license or the other or both...

Okay I need to do a mailmerge into word for reports so that they can be saved and faxed if need. first question is, Do I need to create a word document? 2. Do i really need a report created if its going to be sent to word? 3. what kind of code would I need? anything will help.

I have a group of people in a report and its in sections by what they work in... such as Recieving, packing... so on.. Is there a way to put a total of employees by the section in the report. Like this Section Name Total number in the section...

I have a table for leave. it has a start date and end date. Such as start date 12/6/2004 and End date 12/9/2004 , In my Query I have it where you can enter the date and it will tell you who is on leave for that day as long as its in the start date. Is there a way possible for it to look at both...

PARAMETERS [Forms]![frmMylaunchForm1]![sdate] DateTime, [Forms]![frmMylaunchForm1]![Edate] DateTime; TRANSFORM Sum(Time.[OVER TIME]) AS [SumOfOVER TIME] SELECT Time.[Last Name] FROM [Time] WHERE (((Time.DATE) Between [Forms]![frmMylaunchForm1]![sdate] And [Forms]![frmMylaunchForm1]![Edate]))...

I have a query that deals with a table of time. In that table I have mission/reimbursable work info. In the query , for tasking, if the field is null , it is Mission work and if not then it has a tasking assigned to it. Okay now here is my problem, I am not sure how to find total hours worked...

I have a query I use to run a report. In the report there is a field for mission/reimbursable work. now if the field is blank it is assumed it is mission. I want to know if there is a way to put in a statement such as a Iff statement where it is null will say Mission? Joe

I have 2 tables. One table for time and one for reimbursable time. I want to put the 2 table together in the one time table so it would be easier to manage. In the 2 tables I have 2 things that are the same last name and dates. I want to be able to add everything that has a date and last name...

Sounds easy right... But i am writing a query that need to have either the sum of a day or the sum of a week. here is the problems sometimes a day might have more than one entry. DATE REG HRS OVER TIME Task (SCC) 3/1/2004 8 2.5 1 3/1/2004 8 3...

I have several sums I need to add together to get a total sum of hours in a text box. Only thing is that some of the sums are null(0)and when that happens i only get a blank in total hours. =Sum([reg hrs])+Sum([ANN)])+Sum([SICK])+Sum([OTHER LEAVE])+Sum([OVER TIME] What do I need to do.. Thank...

Here is the deal. I used to have this form and table as a separte database and I consolidated it into a another database. Now when I open up the form and us the combo box I get a run time error 3021 saying no current record found. Here is the script on the combo box. Private Sub...

Right now I have an append Query setup to add users , there hours and date into a table. I am curious is there a way to do this automated, like it adds it to the table every day with out having to run the query. Any info on how or where to look at would be great. Joe

How would you do this with 3 things?? I need a total of hours. I have 3 items that need to be calculated. =sum([item 1]+[item 2]+[item 3]) Is that right?

I have to make a report that will print for each user that i have in my database. It is there timesheets. I want to be able to hit a button and print the reports one user per sheet. How do I make it print one user and the info associated with that user per page? Joe

I have a field for the date, I just figured out the julian date and how it works now I want to update all colum for julian date against the column with the date in it. Do I need to make a query? Thank you, Joe

I have copy and pasted a excel sheet into a report and I want to be able to pull in dates and have them populate areas of the sheet. My question is there will be 14 dates with information in each date. What would be the easiest way to do this. Should I make a footer or something like that with...

I want to build a query that when I put in a date like today for example it will go back 2 weeks and list all the infom from a table. any ideas

I did a search on how to convert the date to julian date, but I am confused. I need it in simple terms. Any help will be great. Thank you

I have a table that I would like to update daily with time. I want to update eveyone on the list with 8 hours. This table is a one to many table to the main table. Any Ideas? Thank you