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 bkrike 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: bowieknife
  • Content: Threads
  • Order by date
  1. 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.
  2. 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.
  3. 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...
  4. bowieknife

    Cocantenate Date and Time from Progressive Records?

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

    Too Many Lines in Chart to Format?

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

    Create a Control Chart

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

    Struggling with Personnel Specific Data

    Hello All - Is there a quick solution for this? I have a TimeCard database (Access 2003) that six personnel use. There is one table that stores data for all employees and one form for entry into this table. Can I have each person "log in" and only add to/edit their records? Thank you in...
  8. bowieknife

    Multi-Layer Conditional IIf Statement

    All - I have a time card database that tracks...well, you get the picture. Within the QryTimeCard (fed by TblTimeCard), I have a conditional iif statement that reads: SunTotal: IIf((([SunTimeOut]-[SunTimeIn])*24)>=8,((([SunTimeOut]-[SunTimeIn])*24)-0.5),(([SunTimeOut]-[SunTimeIn])*24)) and...

Part and Inventory Search

Back
Top