Recent content by JimUK

Duane, Thanks for the input. I'll start with that and see where it leads me. Jim

Whoops sorry! They both contain date and time in the format 12/02/2005 13:00:00 Example: Date of Entry: 12/02/2005 11:10:30 Date of Closure: 12/02/2005 14:00:00

Duane, Thanks for the response. Table name is tblWOLog and their are 2 time fields, DateofEntry and WOClosedDate. Other fields that I'm pulling to make the log entry are, Problem, EmployeeName, Actiontaken and WOStatus. I check both the date fields in my query as there are 2 types of entries...

I have a report that I have been using the DateAdd function to query the last 12 hours for a helpdesk log and that works no problem. Our shifts run from 7am to 7pm (days) and 7pm to 7am (nights). What I would like to do is make a query that would look at the time when generated and only grab...

I am trying to make a report that will act as a logfile of work done in the last 12 hour period. I have no problem with the time and setting up the query. The problem is that I want to see any field that is changed(edited)in that period as well. Is there an easy way to do this? The problem...

Thanks Duane, I'll give it try. Thanks for the input! Jim

Duane, I think you hit the nail on the head. I didn't think about this when I designed it. So, what would be the proper way to setup this new table so that entry would create a separate record for every entry into this field? Table name is tblworkorders, field name is fldActionTaken? Jim

I have a report that I made for a workorder database. This report prints out daily entries made on workorders. As it is now it prints all entries in the memo field, which may be days or weeks worth of work. My question is that I would only like to print the last entry made in a memo field...

Crew is field. I figured it out on my own, silly as it was just used the group option with crew<number> and it works fine thanks for response. Jim

I'm trying to group on part of a text field in a report. Column will have the following: Date Location 29April2005 Station A 02May2005 Station B 06May2005 Station B 07May2005 Station C What I want is a group header based on the A, B or C in...

Bob, That's the ticket, works like a charm! Thanks for all your help as I got a little twisted around the axle as they say. Jim

Update to my last entry. After further testing, the only time the combo's get it right is when there is only one possible system for the title. Some of my PMI Titles will have up to 5 possible systems, some may have only one system. The only one that will show up right is one that has only one...

Bob, It works great the first time but then screws up after that. Let me try to explain: When Title and System are chosen the second time and there after (until form reopened) it seems to display things right in the comboboxes but FindFirst seems to go to the first "system" that it finds in the...

Okay, got 2nd combo figured out and it works fine now. All possible selections automatically drop down when selecting title in first. Had to change cboSelSys Rowsource to the following: SELECT DISTINCT PMI.system FROM PMI WHERE (((PMI.title) = [Forms]![PMI_Signoff_Test1]![cboSelTitle])); SO...

Okay, 1st combo is working fine and typing in works great thanks! The second one comes up blank though. Is this because we don't have an AfterUpdate yet (I took mine out). Jim