Search results for query: *

Company is starting night shifts which are going to have employees clocking in and working past midnight. This is causing our current time and attendance reports to not work as they pull records from 12am - 12am. We need the report, when refreshed to pop up a parameter asking for the day and...

HI Im working on a form in an Access 2007 database where I have two seperate fields on the form that I would like to add together and enter it into a third box on the same form upon submit. The fields I would like to add together are [labor] and [material]. When the submit button is pushed on...

Hi, I'm trying to get averages for columns that are reached by getting counts and sums of the fields but i'm not sure of how to go about it. For Example: Line Count 398 <--(Count of Coitem_line): 45 58 Average: (I need the average of the above)

Hi I am working on a report that tallys jobs with Promise Dates. I need to have a percentage breakdown of how many dates were on time but the problem is, some of the Promise date fields on some of the records are blank, so my total doesn't reach 100%. Is there a way I could count the null...

Hi, I have two laserjets here in my office. One is a HP Laserjet 1320 and the other is an HP Laserjet 2015. They both work fine but have a particular problem that is hard for me to pintpoint. They both print, but between successful prints, they both stop working acting as if nothing was sent to...

Hi, I have a crystal report that is supposed to show the shortest amount of time per job operation. I have all the {jobtran.a_hrs} totalled up into a sum called Sum_jobtran.a_hrs. I have it grouped by job operation so I have a total for each operation. NOW, I need to be able to display the...

Hi I'm looking for some help to write a batch file that I could execute that will delete files from the temporary internet folder, temp folder and the cookies folder in all the user profile folders on a particular machine. The machines run Windows XP Pro and are on a domain. I wasn't sure where...

I am trying to install a 500GB hard drive as a primary master drive on an older machine I built back in 2003. The system is a P4 with 1GB Ram 2.6 GHZ. Its a Shuttle motherboard P4X400 chipset. I installed the drive with the correct jumper settings and when I run the XP Setup disk it only shows...

Hi i'm trying to summarize a formula to calculate daily overtime for employees. This report is grouped by employee and the total needs to be placed in a group footer summarizing a total for OT per employee. The formula references a running total so i'm not sure if i will be able to do it...

Hi Im working on a form in Microsoft Access 2003. This particular form has a combination of about 25 text boxes and combo boxes and two buttons at the bottom. One button leads to another form and I have it disabled when the form loads. I need it to become enabled when all the fields have been...

Can someone show me a loop that does this? im stuck Problem 2-3. Odd Integers Problem. Build an application that adds consecutive odd integers (starting with one) until the sum exceeds a target value. Display the sum and how many integers were added. Not sure of how to go about writing this...

I have a ASP page that is set to auto refresh every 3 minutes. Every now and then I get a 500 error which stops the page. I read about using a DO WHILE LOOP in the page where it will keep trying to get the page until successful. Problem is, Im not really sure about the syntax. Any help would be...

I recently installed a 32 bit program (Mastercam demo 8.1) onto an XP Pro machine to send drawing data to 2 Okuma Mills via Serial Port. The computer is nothing special, its a PIII 324 meg Ram 900 MHZ but it's only running the one program mentioned above. The problem is, when the program is...

I'm currently using WSS 3.0 and am pulling SQL data onto some pages using the DataFormView webpart. I'm trying to figure out how to get a column created on my page using XPath expressions. Basically i'm trying to subtract a table called @hire_date from the Current Date to build a total time...

I'm currently using WSS 3.0 and am pulling SQL data onto some pages using the DataFormView webpart. I'm trying to figure out how to get a column created on my page using XPath expressions. Basically i'm trying to subtract a table called @hire_date from the Current Date to build a total time...

I am building an intranet for my company and am required to display two reports on the home page. When I display the first one, it is fine..but when I add the second one..the first one turns into the second one so I have 2 exact duplicates on the page. I think it has something to do with the...

I want to filter out the fields that have "no data" or null and display them in a report. What type of forumula do I need to identify the null field in record selection? Thanks