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!

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

Recent content by bowieknife

  1. bowieknife

    Conditional Format - More than 3?

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

    Conditional Format - More than 3?

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

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

    Quarter Chart Showing As 22 '06

    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.
  13. bowieknife

    Trendline Parameters?

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

    Trendline Parameters?

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

    Cocantenate Date and Time from Progressive Records?

    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...
See more

Part and Inventory Search

Back
Top