Search results for query: *

If [Veh Code] = 32, 33, 82, 83, 94, or 95 Then [Veh Code] and [Veh Type] and [Sched Date] = vbgreen If [Veh Code] = 14 or 67 Then [Veh Code] and [Veh Type] and [Sched Date] = vbred If [Veh Code] = 01 Then [Veh Code] and [Veh Type] and [Sched Date] = vbblue

Is there an easy way to create more than 3 conditions using conditional formatting on an Access report? If not, is there a good work-around? Thanks.

I'm fumbling in the dark here. Which properties should I be looking at?

This is what it shows: WeekOf Intermodal/Container Rail Truck 5/7/2006 24 7 160 5/14/2006 18 12 162 5/21/2006 37 12 202 5/28/2006 25 13 179 6/4/2006 32 3 170 6/11/2006 6 38

No it doesn't. The datasheet view is great - grouped by weekening dates.

Thanks again dhookum. I'm still getting the date "spread" in between the key "week ending" dates using the DateValue function. What the heck is happening with this chart? I appreciate your help.

It does contain dates and times, for example: Actual Shipment Date 5/23/2006 2:17:04 PM 5/27/2006 12:51:25 PM 5/11/2006 1:03:21 PM 5/12/2006 10:00:28 AM 5/14/2006 5:11:59 PM Sorry for not mentioning that before. Thanks for your patience.

Not sure if this is what you're asking for: TRANSFORM Sum(QryShippingGFP.[CountOfShipment Id]) AS [SumOfCountOfShipment Id] SELECT Format([Actual Shipment Date]-(Weekday([Actual Shipment Date])-8),"Short Date") AS Expr1 FROM QryShippingGFP GROUP BY (Year([Actual Shipment...

No - I'm still getting the blank week days (dates) in between the week ending dates.

Thanks dhookum. Have a star. For the "week ending" chart report mentioned above, I changed the statement to accomodate the format, but now I get the chart displaying all dates along the x-axis, including the days in between the "week ending" dates (which are the only points displaying data...

Thanks d. Here is my current row source: TRANSFORM Sum([CountOfShipment Id]) AS [SumOfCountOfShipment Id] SELECT (Format([Actual Shipment Date],"Q 'YY")) FROM [QryShippingGFP] GROUP BY (Year([Actual Shipment Date])*4 + DatePart("q", [Actual Shipment Date])-1),(Format([Actual Shipment...

Does anyone know how to get a chart to show "1st", "2nd", etc. for a quarterly chart? I utilized the chart wizard and am having trouble with this. Thanks in advance.

Sorry about the data spaghetti there. Basically, I enter in the number of trucks that my plant loads each day. On a column chart report, I have the totals displayed by month. The trend line is linear, and today it displays Jan through April 2006. Unfortunately, with this being the 10th...

Ladies and Gents, I'm having a trendline moment here. I have a few column charts that display totals by month through the current date. I added a trendline, but being that the data tracks through the current date, it gives an inaccurate impression that we are trending down for the first three...

lynchg, Thanks for the assist. Unfortunately I keep geeting Syntax Error messages on the query (due to the &). And yes, the records are in sequential order, with 1 having the date, carrier, etc, and 2 having only data for the date, but that is actually the time (the second half of the first...

I exported data (table) from an Oracle source to excel and then imported this data into an Access DBase. Unfortunately, in the export process date/time fields were split so that the first line in the table gives the following info: Record: 1 Carrier: SouthWay Pickup Date: 1/1/06 Delivey Date...

I have a line chart report (based on a table) that tracks shipments over time. I also have fields included for average, upper limit, lower limit, etc. Access limits selections for the chart to a total of six, so I went into the report in design view and added four more fields for a total of 10...

I am tracking "[Total Shipments]" in a table ("TblServiceMetrics") by date and displaying this data in a "line-dot" chart on a report. How can I add the upper and lower control limits and center line to the chart? I have a query that calculates each with the following formulas: Upper Control...

Right now they do. I would prefer the password system take care of that for them.

Each record is identified to an employee by their name (first and last in same field). The form displays Mon through Sun, including date, time in, time out, and total time per day. Each record covers one week. It's pretty basic. To search through records, they use the navigation buttons...