Recent content by joe31709

any ideas?

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

Well Rich , I dont have a clue on that. Can you fax a report from Access without printing it out?

The data is stored in a table. I had a report that worked fine, but the report can not be faxed. that is why I was trying to output it into word. When you go from report to rich text you lose alot of spaces and lines with the report. That is why I was trying to do just a mail merge into word...

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.

Thank you, I added a count to my query and then added a footer with this. =Sum([Count]) Thanks. Joe

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

You are da man or woman :D Thank you very much Joe

I read that but I dont understand it. I am alittle slow at times :p my names are Sdate and Edate. Do i add the stuff in to criteria?

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

After I hit the Run Query button I put on there it pops up the parameters but there is exclamation points in between everything. Is that correct? It looks like this... After I fill in the text boxes and hit the button I get Forms!frmMylaunchForm1!Sdate ( I can put the info in there and hit...

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

SELECT [EMPLOYEE].[First Name], Time.DATE, Time.[REG HRS], Time.[JON'S], Time.[Task (SCC)], [EMPLOYEE].Grade, Time.[OVER TIME], Time.[COST CODES], Nz([task (scc)],"Mission") AS NewField, IIf(IsNull([reg hrs]),0,[reg hrs])+IIf(IsNull([over time]),0,[over time]) AS [Total Hours] FROM [EMPLOYEE]...

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