Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lcutliffe
  • Order by date
  1. lcutliffe

    Retreive Records that go past 12AM.

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

    Sum up two existing fields and populate it into a 3rd existing field

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

    Sum up two existing fields and populate it into a 3rd existing field

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

    Formulas to get Averages for COUNT totals

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

    Formulas to get Averages for COUNT totals

    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)
  6. lcutliffe

    How do you count null records

    That little formula did the trick, Thank you :)
  7. lcutliffe

    How do you count null records

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

    Two Laserjets that Print Intermittently

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

    Displaying Minimum Value from SUM Total at bottom of the Report

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

    Batch File to delete all temporary files for all user profiles

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

    XP setup not recognizing my 500GB hard drive properly

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

    Need to summarize a formula

    Thanks LB that worked great!
  13. lcutliffe

    Need to summarize a formula

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

    Form Validation Question

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

    Need some Help

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

    Need some Help

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

    Need help with a Do While Loop

    Problem is fixed thanks for the input sheco appreciate it.
  18. lcutliffe

    Need help with a Do While Loop

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

Part and Inventory Search

Back
Top