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...
Mainly for reporting purposes. Lets say I plugged the data base into a crystal report and I had to drag over a table and wanted to report sums of this derived field, is it going to be there? Thats what I wasnt sure about. If the form calculates it on the fly then where is that calculation if the...
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...
Ok,
My group field is custaddr.name
My sample shows a column of counted lines for each customer. I copied the COUNT total from the Group Footer and pasted it in GH1b for display purposes along with the customer name.
I am trying to get that column of numbers averaged and placed in the report...
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...
Nope, i'm teaching myself how to write VB and using a tutorial I found on the NET, was going along great till I hit this problem..It pertains to the LOOP chapter I just read but I'm not sure how to do it and it doesn't have the answer in the tutorial. Just lookin for a nudge to keep me goin. I...
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...
%>
<meta http-equiv="Refresh" content="180;URL=Plant 6 Rod Schedule v1.3-dynamic.asp?
<%
Thats the method it is refreshing by. Sorry for the vague explanation.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.