Search results for query: *

Ok, I'm stumped. I'm grouping by week and want to get a sum for TD1OZ, TD2OZ and TD3OZ broken out by PreHH and PostHH. I'm just having a hard time wrapping my brain around how to sum these totals. I can sum for all of TD1OZ, but can't figure it out how to break it out. (then for extra credit...

Why on earth am I getting an extra day (Dec 31st)?? Too many ")"? HAVING (((ProdJobABEND.DATE)>DateAdd("m",-18,(Now()-(Day(Now())))) And (ProdJobABEND.DATE)<=Now()-Day(Now())));

I've been staring at this too long. Why am I getting this error with this formula: "Too many arguments have been given to this function." iif( Length ({ProdJobABEND.TIME})>10, time(5,5,5), (Time( (Mid ({ProdJobABEND.TIME},9,2)), (Mid...

I'm having a slew of minor annoyances with CR XI and visited the tech support website. It appears there are a few HotFixes which will take care of virtually everything. I have downloaded the Release 1 hot fix and release 2 hot fix (and being a bad user - installed them both). I'm still having...

Table 1: Days - Date Table 2: System Name - Text Table 3: Event Failure Date System Name Job Number Failure Job ID Table 4: Event Sucess Date System Name Job Number Success Job ID I'm linking: From Table 1 Date to Table 3 Event Failure Date (left outer join) From Table 1 Date to Table 4...

I have a way to convert Epoch to CDT (If you want that formula, I'm happy to share), but now need to convert a CUT time and date stamp with our local time. In Chicago we observe Daylight savings. Help computer! http://en.wikipedia.org/wiki/Coordinated_Universal_Time

I have a dataset which has the dates a job has failed. In my report, I'm grouping by month. There are some months where I don't have any data, yet I want to display the date as a blank. How? The data looks like this: Jan Mar April July 1 10 12 4 I want it to look like...

Table 1: Job Name, Job down date (and a bunch more things) Table 2: Issue description, Issue enter date (and a bunch more things) The Job name in table 1 is somewhere within the Issue description of table 2. There can be text before and/or after the job name in the Issue Description of table...

I'm beating my head against the wall on this one. I want to run a report during a month and have the date range be "past 3 months". Help computer!

I've got a very basic report completed which first groups by day then by application type. My database has a table with 3 fields: Application type (See above), order # and application detail. Application type is a unique Order number is a number from 1-10 Application detail is text (255chrs)...